Backup SOHODOX DBs using SQL Server Management Studio

Backup SOHODOX DBs using SQL Server Management Studio

To backup 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' on the left of the screen, expand the 'Databases' node.
  6. Right-click 'MainDB_sdx'. Click on 'Tasks'>>'Backup...'
  7. In the General node, in the 'Destination' section, click on 'Add...'
  8. The 'Select Backup Destination' window will be launched.
  9. On the 'Select Backup Destination' window, click on the [...] besides the File name option.
  10. The 'Locate Database Files' window will be launched.
  11. In the File name textbox at the bottom of the window type 'MainDB_sdx(Date).bak' 

    NOTE - Its important to put the date, so its easy to know when was the backup last taken. We recommend you to follow the same date format.
    For example, 'MainDB_sdx(16nov2022).bak' 

  12. Once named the file as above, click 'OK' and on the 'Select Backup Destination' window again click 'OK'.
  13. On the 'Back Up Database' window under the 'Destination section' at the bottom, carefully remove the old backup destination (if any) by clicking on the old backup destination and clicking on the remove button on the screen.

    CAUTION - Do not remove the new destination we recently created with the date at the end of it. 

  14. Go to the 'Media Options' node left of the screen.
  15. Under the 'Overwrite media' section, select option 'Overwrite all existing backup sets' & under the 'Reliability' section select option 'Verify backup when finished'. 
  16. Once done, click OK.
  17. The 'Microsoft SQL Server Management Studio' window will pop-up saying 'The backup of database 'MainDB_sdx' completed successfully'. Again click OK.
  18. Now under the Databases folder which we expanded earlier, follow the same backup steps (Step 5 to step 17) for DB 'MainDB_sdx_cache' 

    NOTE - Its important to put the date, so its easy to know when was the backup last taken. We recommend you to follow the same date format.
    For example, 'MainDB_sdx_cache(16nov2022).bak'

  19. The backup for the DB's is completed.

    (Please follow the same steps for all the DB's you want to Backup).