Changing Dump Location for MSSQL Backup

Changing Dump Location for MSSQL Backup

KB ID: 115033
Cause:
If you have configured MSSQL backup with a dump location and need to change it to another location, follow the steps below as it's currently not possible to change it through the web console.
Solution:
To change the default dump location in BDRSuite, use the following steps:
1. Suspend the specific backup schedule from the UI.
2. Stop BDRSuite                                                                                                           
3. Open the command prompt with 'Run as Administrator' privilege and navigate to the BDRSuite installation location.
4. Run the command to access the client database:
   lib\sqlite\sqlite3.exe data\sgclient.db   
Note: If you have a different DB storage location, specify the exact path of the sgclient.db.
5. Run the following SQL Query to update the Backup Location:
update backupconfig set location='<new_dump_location>' where backupname='<backup_name>';
Replace `<new_dump_location>` with the new dump location and `<backup_name>` with the BackupName of the backup schedule.
6. Quit the SQLite application using the ".q" command.
7. Start BDRSuite Application.
8. Run an additional full backup for the backup schedule by editing the backup details and enabling the 'Run additional full backup after saving this configuration' option.
By following these steps, you can successfully change the dump location for MSSQL backup in BDRSuite.

    • Related Articles

    • Troubleshooting: Failed to Create Dump Location

      KB ID: 110002 Cause: This error typically occurs when the configured dump location for MSSQL backup schedules is inaccessible, or the user running the BDRSuite service lacks sufficient permissions to access the directory. Solution: To resolve this ...

    • Error Creating Dump Location in MS Outlook Backup

      KB ID: 34 Error Message: Encountering the error: "Error while creating the dump location <Dump Location> - MS_Outlook." Cause: The configured dump location for the specified backup schedule is either inaccessible, or BDRSuite lacks sufficient ...

    • Changing BDRSuite Client Data Storage Location

      KB ID: 115097 Purpose: To migrate internal database files of BDRsuite Client from one location to another. Cause: In BDRSuite client, when a significant number of files are added to the backup job, the internal meta-information (sgprp database) ...

    • Unable to Access the Dump Location

      KB ID: 113002 Cause: The configured dump location for a specific backup schedule is inaccessible or BDRSuite lacks sufficient permissions to access the directory. Solution: Follow these steps to resolve the issue: 1. Verify that the dump location ...

    • Resolve MS Outlook Error: Insufficient Space in Dump Location for PST File Export

      KB ID: 32 Issue: Encountered error: "Dump location does not have enough space to export the PST file" in MS_Outlook during backup with BDRSuite Cause: Insufficient free space in the configured dump location for this backup schedule, preventing ...