Restoring Database onto SQL Server
The following instructions present how a user can restore a database onto the SQL server.
Through the File Explorer or any internet browser, the user opens the link http://ftp.datalab.eu/databases/.
By clicking the correct database from the list below, the user can download different databases.
| EU_FA.zip |
An empty farming database with English collation. |
| EU_FA_DEMO.zip |
A DEMO farming database with English collation. |
| EU_LT.zip |
An empty database with English collation for owners of LT licenses. |
| EU_LT_DEMO.zip |
A DEMO database with English collation for owners of LT licences. |
| EU_MF.zip |
An empty database with English collation for owners of other PANTHEON licences. |
| EU_MF_DEMO.zip |
A DEMO database with English collation for owners of other PANTHEON licences. |
| EU_VET.zip |
An empty database with English collation for owners of VET licenses. |
| EU_VET_DEMO.zip |
A DEMO database with English collation for owners of VET licenses. |
The file is normally downloaded to the Downloads folder (computer setting).
After downloading the database from the FTP server, it must be expanded from the archive with a suitable archiver.
 |
WARNING
For quick decompressing of archival files, the free archiver 7zip is recommended.
|
The user saves the downloaded and decompressed backup copy of the database (ending .bak) from the archive to the place set when installing the SQL server – the backup folder.
In this case, the user selects the file C:\#sql\backup.
In the Start menu, the user finds Management Studio and runs it. When the program is running, the user logs into the SQL server.
After logging into the SQL server, the user expands the instance (usually .\DATALAB) by clicking the plus in the Object Explorer.
The user marks and right-clicks the Databases and selects the menu Restore Database.
A new Restore Database window opens.
In the menu, under Source, the user selects the checkbox Device, then selects ..., to open a new chat window Select backup devices.
By clicking the Add button, the user finds the database, which was previously downloaded from the FTP server and expanded with a suitable archiver.
The user finds the decompressed database on the hard drive (usually named SI_XX.bak), marks it and confirms the choice by clicking the OK button.
After selecting the database, the user confirms it by clicking the OK button in the Select backup devices window.
The Restore Database window offers the user the option to name the database on the SQL server in the Database field of the Destination section.
Normally, the database is named with the short name of the company for which the new database is being mounted.
When naming a database, you can confirm the restoration of the database on the SQL server with the OK button in the Restore Database window.
|
WARNING
- Management Studio restores the database to the path set when installing the SQL server (data, log). For more information, see the chapter Download and Installation.
- If you want to change the location of the restored (.mdf and .ldf) files, you can change the location in the Select a page | Files section.
-
The database can also be restored manually, through the SQL editor with the command:
RESTORE DATABASE [SI_MF] FROM DISK = N'C:\#sql\backup\SI_MF.bak'
WITH FILE = 1,
MOVE N'DataLab_Data' TO N'C:\#sql\data\MOJA_PRVA_PRAZNA_BAZA.mdf',
MOVE N'DataLab_Log' TO N'C:\#sql\log\MOJA_PRVA_PRAZNA_BAZA_1.ldf',
NOUNLOAD,
STATS = 5
GO
|
If your database is successfully restored onto the SQL server, it is visible in the Object Explorer window, in the Databases section.
The user wants to check the database version. The user selects and right-clicks the database and selects New Query.
In the SQL editor, the user enters the command: select * from tpa_sysparamsys
In the anBuildNo. column on the Results tab, the user reads the database version.
The user must know the database version to download the correct PANTHEON program package from the FTP server.
|
WARNING
After restoring the database, the users must be transferred from the database to the server level. For more information, see the chapter Adding Users to Server Level (AddUser_PAX).
|