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.