To restore the Microsoft SQL database, in addition to the Xopero application, it is also necessary tool for database management - Microsoft SQL Server Management Studio Express which is available to download under: https://www.microsoft.com/en-us/download/details.aspx?id=29062.
Download the database backup
In order to download the Microsoft SQL database backup run the Xopero application and then go to the Restoring tab. All backed up databases will be in Microsoft SQL Server branch.

Expand the branch and mark the checkbox at the database which has to be restored and the click on the Restore selected button.
In order to restore selected version of the database right click on its name and from context menu select Show file versions.
The file restore settings window will be displayed where you have to select the location where the database backup file has to be saved. From this directory it will be also restored to the database server.

Restore the database from downloaded file
In order to restore the downloaded Microsoft SQL database, to the database server run Microsoft SQL Server Management Studio.

After correct login to the Microsoft SQL server right click on Databases branch and, from context menu, select Restore Database option.
In displayed window select Device option and then choose previously downloaded database backup. Then in Destination field select the database to which backup will be restored (it is necessary). If the database does not exist, it is required to create it.

If the restored database file contains incremental backup, there will be available list of included backups. They correspond to each version of the database, making it possible to restore previous state of the database.
Click OK in the bottom part of the window to start the restore process to the Microsoft SQL server.
The transaction log can be restored only after restoration of the full database version from given period of time or by using all transaction logs since last full database copy. It is required to restore them in order from oldest to newest. It could be necessary to use option RESTORE WITH NORECOVERY.
Possible errors
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'testowa_baza' database
The error occurs while trying to restore the database which already exists in the database server. To solve it go to Options page in the database restore window and select the Overwrite the existing database. It overwrites the existing database.

System.Data.SqlClient.SqlError: This differential backup cannot be restore because the database Has been restored to the correct earlier state.
The error occurs when Xopero application has been made the differential database dump and another application made full dump the database. To restore the database it is required to use its last full dump and then the differences could be restored from Xopero backup file.
System.Data.SqlClient.SqlError: The file: 'C:\....' cannont be overwritten. It is beign used by database 'BazaDanych'.
The error occurs while database file could not be overwritten, because it is still in use. To solve this problem go to the Files page in the database restore window and change the file name to which database has to be saved. Click on field Restore As and provide new filename.

Comments
0 comments
Please sign in to leave a comment.