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).

    • Related Articles

    • Restore SOHODOX DBs using SQL Server Management Studio

      To restore 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 ...
    • 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 ...
    • 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 ...
    • 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 ...