Restore SOHODOX DBs using SQL Server Management Studio

Restore SOHODOX DBs using SQL Server Management Studio

To restore the DBs using SQL Server Management Studio follow the steps below:

  1. Open 'SQL Server 2014 (or any) Management Studio'. 
  2. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication'.
  3. Please enter your MS SQL credentials in the login box.​




  4. Click Connect.
  5. In the 'Object Explorer' at the left of the screen, right-click 'Databases' and select 'Restore Database...'
  6. Choose 'Device' under the 'Source' section and click on the [...] button.
  7. On the 'Select Backup Devices' window, click on 'Add'.
  8. Select the DB you want to restore and click OK. (SQL Backup DBs are usually stored in the 'C:\Program Files\Microsoft SQL Server\MSSQL12.SDXSQLEXPRESS\MSSQL\Backup' folder)
  9. Click on the 'Verify Backup Media' button at the bottom of the window.
  10. You should be able to see the confirmation message 'Backup media verified successfully' at the top of the screen.
  11. Now, go to the 'Files' section under the 'Select a Page' section at the left of the screen.
  12. Check the option 'Relocate all files to folder'.
  13. Now, go to the 'Options' section under the 'Select a Page' section at the left of the screen.
  14. Under the 'Restore options' check the option 'Overwrite the existing database (WITH REPLACE)'
  15. Click on OK.
  16. The 'Microsoft SQL Server Management Studio' window will pop up saying 'Database restored successfully'.

    (Please follow the same steps for all the DBs you want to restore)