Answered

Change default location of database Back-up during deployment

I would like to have a way to change where the back-up occurs during a deployment. Presently the location is coded to the default database location which is usually not accessible to anyone but a DBA. If I could change this location during the runtime of the deployment, it would make things much easier.Thanks

Best Answer
photo

Dear Billy,

Bizagi does not allow you to modify this path for local projects and where the SQL server is local. When the database is remote, you have a way to change it because that depends of the SQL Server but it will modify for all your backups by default no only Bizagi projects.

For further information: http://www.sqlservercentral.com/blogs/steve_jones/2011/06/09/sql-server-default-backup-directory/

These steps are from the article:

Note that the “MSSQL.1” might be different, depending on your instance. For me it’s SSQL10.MSSQLServer.backupdir_thumbNote that there’s a “BackupDirectory” key here. You can double click it to change the path:backupdir2_thumbI changed mine to a new path, c:\sqlbackup. Note that I had to create this folder.change-path_thumb

Regards

photo
0

Dear Billy,

Bizagi does not allow you to modify this path for local projects and where the SQL server is local. When the database is remote, you have a way to change it because that depends of the SQL Server but it will modify for all your backups by default no only Bizagi projects.

For further information: http://www.sqlservercentral.com/blogs/steve_jones/2011/06/09/sql-server-default-backup-directory/

These steps are from the article:

Note that the “MSSQL.1” might be different, depending on your instance. For me it’s SSQL10.MSSQLServer.backupdir_thumbNote that there’s a “BackupDirectory” key here. You can double click it to change the path:backupdir2_thumbI changed mine to a new path, c:\sqlbackup. Note that I had to create this folder.change-path_thumb

Regards