Quick, easy and useful
- Get backups off site quickly and simply, without the hassle of tape
- Recover your data whenever you want
- Manage your backups online
- Delete old backups automatically
How does it work?
Use the SQL Backup Pro wizards or scripts to create a backup on disk and copy it to your secure Hosted Storage account. You will still benefit from SQL Backup Pro's compression, encryption, network resilience and more.
How secure is my data?
Your data is uploaded over a secure HTTPS connection to your SQL Backup Pro Hosted Storage account.
To find out more, read our FAQ.
Automated from within SQL Backup Pro
- Upgrade to SQL Backup Pro 7.3 or later
- Link your SQL Servers to your Hosted Storage account
- Within SQL Backup Pro's backup wizards, simply tick the option to copy the backup to hosted storage
SQL Backup Pro Hosted Storage provides online storage for SQL Server backups created with Red Gate's SQL Backup Pro. When you take a backup with SQL Backup Pro, you can choose to upload a copy of the backup to hosted storage as part of the process. Your backups are stored securely and can be downloaded whenever you need them.
To get started:
- If you're an existing SQL Backup Pro user, select Check for Updates (from the Help menu) to upgrade to SQL Backup Pro 7.3 or later, then upgrade the SQL Backup Pro server components on each of your SQL Servers. Alternatively, download and install SQL Backup Pro from the Red Gate website.
- Create a SQL Backup Pro Hosted Storage account.
- Link your SQL Server to your Hosted Storage account from the backup wizards or the Server Options dialog.
- Use the Back Up or Schedule Backup Jobs
wizard to create a backup and select Copy
backup to hosted storage. You can
WITH COPYTO_HOSTEDto a backup script. Once SQL Backup Pro has written the backup to disk, it uploads a copy to your Hosted Storage account.
- Log in to your account to view your uploaded backups.
For more information, see Backing up to hosted storage.
Where are my backups stored?
When you upload your backups to a SQL Backup Pro Hosted Storage account, they are stored in Red Gate's Amazon S3 space, which is hosted in the US and backed by the Amazon S3 Service Level Agreement. While your backups are stored in your Hosted Storage account they are subject to Amazon's Customer Agreement.
How do I access my backups?
You can view, download and delete your backups by logging in to your account. Your backups are not visible to other users of SQL Backup Pro Hosted Storage and Red Gate will never access your backups without your express permission.
How secure is my data?
Your backups are uploaded over a secure HTTPS connection to Red Gate's Amazon S3 space. Your account password is not stored on your machine and is not sent to the web server as part of this process.
If you wish, you can use SQL Backup Pro's 128-bit or 256-bit encryption to encrypt the backup as it is written to disk. The encrypted backup file is then uploaded and stored in your Hosted Storage account.
Can I upload backups to my own Amazon S3 or Azure Storage account?
No, it is only possible to link a SQL Server instance to a SQL Backup Pro Hosted Storage account.
Can I specify which region my backups are stored in?
No, SQL Backup Pro Hosted Storage uses Red Gate's Amazon S3 space in Amazon's US Standard Region.
How long will my backups remain in hosted storage?
Your backups will remain in your SQL Backup Pro Hosted Storage account until you delete them or close your account. If you want to close an account, download any backups you require first. For more information, see How do I close my account?
How much does it cost to store my backups in SQL Backup Pro Hosted Storage?
For each SQL Server instance with a SQL Backup Pro license (or active trial), you can store up to 5GB of data for free. After that, we will charge you $0.50 per GB per month. You are only charged for the space you use.
Are there any additional costs for uploading or downloading files?
No, the cost is simply $0.50 per GB per month for anything over 5GB. If you store 5GB or less, you can upload and download backups at no cost.
How will I be charged for using SQL Backup Pro Hosted Storage?
If you store more than 5GB of data we will ask you to provide your credit card or PayPal account details through a service called FastSpring. We will charge you each month for the storage space you are using at the end of the previous month.
Is there a limit to the amount of data I can store each month?
No, there is no limit on how much data you can store. You will be charged each month for the space you have used in the previous month.
How can I keep track of how much space I have used?
You can see how much space you have used by looking at the sizes of the backups in your account on the My backups page. Your backups are listed by SQL Server instance, so you can see whether you have exceeded your 5GB allowance for each instance.
How long will it take to upload a backup to my Hosted Storage account?
The time required to upload a backup to hosted storage depends on the size of the backup file and your internet bandwidth.
You may find it helpful to split a backup into multiple files. The files will be written to disk concurrently, but will be uploaded to hosted storage sequentially. You can choose to split a backup into multiple files on step 3 of the Back Up wizard (step 4 of the Schedule Backup Jobs wizard), or using the SQL Backup syntax.
When are my backups uploaded to hosted storage?
Each backup is written to the disk location you specify before SQL Backup Pro starts uploading a copy to hosted storage.
The progress of the upload is displayed in the SQL Backup GUI In Progress tab. Once the upload is complete, the backup is listed in the Activity History as Successful and the files are listed in your Hosted Storage account.
It is not currently possible to create separate schedules for writing backups to disk and uploading them to hosted storage.
What happens if my backup job creates multiple backup files?
If you have split a backup into multiple files, all the files will be written to disk before SQL Backup starts uploading a copy to hosted storage.
If you are backing up multiple databases at a time, each backup is written in sequence. SQL Backup will start uploading the first backup once it has been written to disk.
Can I edit existing backup jobs to include the "copy to hosted storage" option?
- In the SQL Backup GUI, open the Jobs tab and double-click the backup job you want to edit. The Edit Backup Job wizard is displayed.
- On step 3 of the wizard, select Copy backup to hosted storage.
- On the final step, click Finish to save the changes to the job. The next time the job runs, a copy of the backups will be uploaded to your SQL Backup Pro Hosted Storage account.
Alternatively, edit the job in SQL Server
Management Studio and add
to the SQL Backup job step.
Can I upload a backup to hosted storage without creating a backup on disk?
No, it is not possible to write a backup directly to hosted storage.
Can I limit the amount of bandwidth used by the upload process?
No, it is not possible to limit the amount of bandwidth that SQL Backup uses to upload a backup to hosted storage.
Can I pause or cancel an upload?
Once a backup file has been written to disk, you can cancel the upload of that file to hosted storage using the SQL Backup GUI:
- On the In Progress tab, select the file you want to stop uploading. Files are listed as Pending between upload attempts and Uploading during upload attempts.
- Right-click the file and select Cancel Upload.
- A confirmation dialog is displayed. Click OK to cancel the upload.
Cancelling the upload of a file does not affect the backup that was written to disk. The backup is listed in the Activity History as “Successful (with warnings)”, and the Backup Properties indicate that the upload to hosted storage was cancelled.
If you want to upload the file at a later date, the easiest option is to take the backup again, selecting Copy to hosted storage as before. If you do not want to take the backup again, you can use a command line utility to upload a copy of the file to hosted storage. See Using SQBHostedStorageClient.exe for more information.
It is not possible to pause and later restart the upload process.
What happens if the upload is interrupted or fails?
If the internet connection is interrupted or a problem occurs while a backup file is being uploaded to hosted storage, SQL Backup will again try to upload the file at regular intervals for the next 24 hours. The backup file will be listed in the SQL Backup GUI In Progress tab as Pending between upload attempts, or In progress during attempts. Once the backup file has been uploaded, the entry will be removed from the In Progress tab and the backup file will be listed in your SQL Backup Pro Hosted Storage account.
If the backup file could not be uploaded to your Hosted Storage account, the backup will be listed in the SQL Backup GUI Activity History as Successful with warnings. Double-click the entry to view the Backup Properties and warning or error messages.
To try uploading again, either create another backup and upload it, or use SQBHostedStorageClient.exe to upload the existing file again. For more information, see Backing up to hosted storage.
Can I specify a retention policy to automatically delete old backups from my account?
You can specify a single retention policy that will apply to all backup files in your account 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.
Note: A day is calculated as a period of 24 hours from when the retention policy was applied and takes no account of calendar date.
Can I restore a database from a backup in my Hosted Storage account?
It is not possible to restore directly from a backup in hosted storage using the SQL Backup Pro GUI. To restore from a backup in hosted storage:
- Download the files you require from the My backups page.
- In the SQL Backup Pro GUI, open the Restore wizard and on step 1, select Browse for backup files to restore.
- Select the SQL Server you want to restore to.
- Click Add Files and browse to the location of the downloaded files and select them, then click OK.
- Complete the wizard to restore the backup. For more information, see Restoring backups.
How do I create a SQL Backup Pro Hosted Storage account?
To create a SQL Backup Pro Hosted Storage account, go to http://sqlbackup.red-gate.com. You will need to install SQL Backup 7.3 or later and link a SQL Server to your account to be able to copy backups to hosted storage.
You can download the latest version of SQL Backup from the Red Gate website.
For more information about linking accounts and copying backups to hosted storage, see Backing up to hosted storage.
Is my SQL Backup Pro Hosted Storage account the same as my Red Gate account?
No, your SQL Backup Pro Hosted Storage account is separate to the Red Gate account you use to view serial numbers, saved quotes and invoices.
Can I create multiple accounts?
Yes, there is no limit to the number of SQL Backup Pro Hosted Storage accounts you can create. However, you can only link a SQL Server instance to one Hosted Storage account.
You can link the same SQL Backup Pro Hosted Storage account to multiple SQL Servers; the uploaded backups will be sorted by instance name.
How do I unlink my account from my SQL Server?
If you need to unlink an account, delete the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance>\HostedStorageToken
It is not possible to unlink a SQL Server from your account using the SQL Backup GUI.
How do I close my account?
Download any backups you require and delete them from your SQL Backup Pro Hosted Storage account, then email firstname.lastname@example.org. Any backups remaining in your account will be deleted when the account is closed.
I've forgotten my password. How do I reset it?
To reset your password, please email email@example.com. We will send you a temporary password so you can log into your account. You can then change your password on the Account Settings page.
I've received an email about a SQL Backup Pro Hosted Storage account, but I haven't created one. Who should I report this to?
Please email firstname.lastname@example.org.