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 BDRShield, use the following steps:
1. Suspend the specific backup schedule from the UI.
2. Stop BDRShield                                                                                                           
3. Open the command prompt with 'Run as Administrator' privilege and navigate to the BDRShield 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 BDRShield 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 BDRShield.

    • 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 BDRShield 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 BDRShield lacks sufficient ...

    • Changing BDRShield Client Data Storage Location

      KB ID: 115097 Purpose: To migrate internal database files of BDRsuite Client from one location to another. Cause: In BDRShield 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 BDRShield 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 BDRShield Cause: Insufficient free space in the configured dump location for this backup schedule, preventing ...