Take a database backup using Red Gate SQL Backup
david.conlin
Posts: 53
A lot of people want to back up their database before they deploy to it.
One way to do this using Red Gate's SQL backup tool is to package up the script below and to deploy it as a step before doing a database deployment.
You'll need to configure the following variables in Deployment Manager for this step:
SqlBackupLocation: The place you installed SQL Backup to.
ServerInstanceName: The name of the SQL Server, as it's saved on your SQL Backup configuration
RedGateDatabaseName: The name of the database to be backed up
BackupLocation: Where to put the backup
Password: The password to encrypt the backup with.
For example:
One way to do this using Red Gate's SQL backup tool is to package up the script below and to deploy it as a step before doing a database deployment.
& "$SqlBackupLocation\$ServerInstanceName\SQLBackupC.exe" -SQL "BACKUP DATABASE `"$RedGateDatabaseName`" TO DISK = '$BackupLocation\<auto>' WITH PASSWORD = '$Password'"
You'll need to configure the following variables in Deployment Manager for this step:
SqlBackupLocation: The place you installed SQL Backup to.
ServerInstanceName: The name of the SQL Server, as it's saved on your SQL Backup configuration
RedGateDatabaseName: The name of the database to be backed up
BackupLocation: Where to put the backup
Password: The password to encrypt the backup with.
For example:
David Conlin
Software Developer
Deployment Manager
Software Developer
Deployment Manager
