Backup and Restore > Manually restore a backed-up DB

You are here: Backup and Restore >Manually restore a backed-up DB

You will require the latest Backup copy of the MainDB_sdx and the MainDB_sdx_cache, and their linked folder which contains the File Store. Also see, Backup a Sohodox DB

To manually restore a Backed-up Sohodox DB:

1.	Make sure Sohodox is not running. Click Start > All Programs > MS SQL Server 2012 > SQL Server Management Studio. The SQL Server Management Studio will now be launched.

2.	Enter your login details and connect to the server.

3.	Select the Databases folder in the left pane, all the databases will now be displayed in the right pane.

4.	Right-click any database from the list and select Tasks > Restore > Database... option. The Restore Database window will be launched.

5.	Select the Device option. Click this [...]button to specify the location of the backed up file ie MainDB_sdx. The backed up file will have a .bak extension.

6.	Click the OK button to begin the restore. Once the restore is complete you will get a confirmation message, click OK.

7.	Now, restore MainDB_sdx_cache from the list and follow step 4-6 to restore this DB.

8.	Once you have restored MainDB_sdx and MainDB_sdx_cache, close the SQL Server Management Studio.

9.	Now that you have restored the DB, you will now have to restore the DB's File Store i.e. its linked folder which contains the File Store.

10.	Now, unzip this backed up folder that contains the File Store i.e. the MainDB folder and add it to the folder where Sohodox databases are stored. This is usually the C:\Sohodox Databases folder.

•	The restore process may take some time depending on the size of the backed-up Sohodox DB being restored.