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)

    • Related Articles

    • Backup SOHODOX DBs using SQL Server Management Studio

      To backup the DBs using SQL Server Management Studio follow the steps below: Open 'SQL Server 2014 (or any) Management Studio'. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication' Please enter your MS SQL ...
    • Attach MDF and LDF files to SQL Server Management Studio

      If you are using SQL Express Edition, please download the SQL Server Management Studio from the link below...  https://www.microsoft.com/en-in/download/details.aspx?id=42299  Please download the file 'MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe' ...
    • Convert your existing SQL Express Sohodox DB to SQL Server Standard/Enterprise Sohodox DB

      Note: The below instructions will only work if… You have an existing installation of SQL Server Standard or Enterprise (if you are unsure, drop an email to support@sohodox.com) You have purchased the SQL Server upgrade module. You have the new ...
    • Backup using the new SOHODOX Database backup utility

      Please note this utility will backup only the database and not the documents. Please download the SOHODOX DB backup utility from the link below… https://downloads.sohodox.com/tools/backup/latest/sohodox-backup-database.zip Instructions… Make sure no ...
    • SQL: 001 : SQL Server does not exist or access denied

      Error Message: ErrorCode: 61443 Message: Failed to connect to database 'MainDB_sdx'. (ErrNo:-2147467259 Details:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.) Cause: The error indicates that SOHODOX is unable to ...