The SQL Backup Pro Hosted Storage service will be closing down at the end of 2017. We will assist customers who use the service to migrate to storing backups in Amazon S3.
Email support@red-gate.com for further information. |
Backing up to hosted storage is only available in SQL Backup Pro 7.3 and later. |
Hosted storage is a service provided by Redgate which allows you to store backups created with SQL Backup Pro off-site and access them online.
You can upload a copy of a backup to hosted storage as part of a backup job. Using the SQL Backup Pro Hosted Storage website, you can access your backups whenever you need them.
For more information, see the SQL Backup Pro Hosted Storage website.
In order to upload backups to hosted storage, you need to:
For each SQL Server you want to upload backups from, link the server to your account. You can do this when creating a backup job, on step 3 of the Back Up wizard (step 4 of the Schedule Backup Jobs wizard). Under Hosted storage, click Link Account. Enter your account email address and password and click Link Account.
Alternatively, from the Tools menu, select Server Options. Open the Hosted Storage Settings tab and select the SQL Server that you want to link to your account. Enter your account email address and password and click Link Account.
If you have multiple SQL Server instances, you will need to link each one to an account. This can be the same account, or a different account for each server.
Once your account is linked, you can copy backups to hosted storage using either the SQL Backup Pro wizards, or a SQL Backup Pro script.
Note: Your password is not stored on your machine. |
On step 3 of the Back Up wizard (step 4 of the Schedule Back Up Jobs wizard), select Copy backup to hosted storage.
Complete the wizard to create the backup or schedule the job. All other backup options, including copying to a network share, encryption, and compression, are available when backing up to hosted storage.
Once the backup has been written to disk, SQL Backup Pro starts uploading a copy of the backup to hosted storage. See Viewing the progress of uploads to hosted storage below.
To copy a backup to hosted storage, add COPYTO_HOSTED
to the WITH
clause of a backup script, and run it from the command line or extended stored procedure.
For example, using the extended stored procedure:
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [pubs] TO DISK = ''C:\Backups\pubs.sqb'' WITH COPYTO_HOSTED " ' |
Using the command line:
-SQL "BACKUP DATABASE [pubs] TO DISK ='C:\Backups\pubs.sqb' WITH COPYTO_HOSTED |
The other backup options in SQL Backup Pro, including COPYTO = <network location>
, KEYSIZE = 128|256
, and COMPRESSION = 1|2|3|4
, can be used in conjunction with COPYTO_HOSTED
.
For more details, see The BACKUP command.
If you already have backup jobs set up, you can edit them to copy the backups to hosted storage as part of the job.
Alternatively, edit the job in SQL Server Management Studio, adding WITH COPYTO_HOSTED
to the SQL Backup job step.
When backing up to hosted storage, you can both split backups into multiple files and back up multiple databases at the same time.
For more information on backing up multiple databases, see Backing up all databases on an instance.
Once the backup has been written to the disk location you specified, SQL Backup Pro starts uploading a copy of the backup to your Hosted Storage account.
You can view the status of the upload from the In Progress tab:
The backup is listed in the Activity History as Successful (awaiting copy to hosted storage) while the upload is in progress. Right-click the row and select Properties to view the status of each file. Once the upload has completed, the backup is listed as Successful.
To cancel an upload that is in progress, open the In Progress tab, right-click the row and select Cancel. This will not affect the backup written to local disk. It is not possible to restart an upload after it has been cancelled.
If an upload attempt fails, for example because the network connection was interrupted, SQL Backup Pro will attempt to upload the file again at regular intervals. In between attempts, files will be listed in the In Progress tab as Pending. For information about the cause of the failure, right-click the row and select Show Log, or in the Activity History, right-click and select Properties.
SQL Backup Pro will continue retrying the upload at increasing intervals for 24 hours.
To prevent any further upload attempts, open the In Progress tab, right-click the upload and select Cancel. This will not affect the backup written to local disk.
If the backup fails to upload after 24 hours, or the upload is cancelled, the backup will display in the Activity History as Successful (with warnings). Right-click and select Properties to see details of the problem.
To try uploading again, take a new backup of the database and select Copy backup to hosted storage. Alternatively, use SQBHostedStorageClient.exe to upload the backup manually. For more information, see SQBHostedStorageClient.exe.
For more about the upload schedule and changing the behavior of it, see The In Progress tab.
You can manage your backups in hosted storage using the SQL Backup Pro Hosted Storage website.
You can view your backups in the My backups page, organised by SQL Server instance and by upload date.
To download a backup file, click the download button on the right of the file you want to download.
To delete individual backup files, click the delete button on the right.
To delete all backups older than a specified age automatically, set a retention policy on the Backup retention page. The retention period for each file is calculated from the date and time the file was uploaded. When you apply a retention policy, any files older than the retention period are deleted immediately and cannot be recovered. Remaining files are automatically deleted at the end of the retention period.
A day is calculated as a period of 24 hours from when the retention policy was applied and takes no account of calendar date |
Check that you no longer need a backup before deleting it or setting a retention policy: there is no way to retrieve a backup once it has been deleted from hosted storage. |
To restore a database from a backup in hosted storage:
In SQL Backup Pro, open the Restore wizard. On step 1, from the drop-down list, select Browse for backup files to restore.