SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Backup to the Cloud - No Excuses

By Brad McGehee,

I used to work at a multi-billion dollar organization and, like most organizations that big, they kept backups of all their databases offsite in case some major catastrophe destroyed the data center. There was only one problem with their otherwise excellent plan; the offsite location for the backup tapes was the building next door, a mere 50 yards from the data center. Any disaster spectacular enough to take out the data center would most probably have damaged or leveled the building next door.

When I have been in charge of SQL Server backups, I’ve always made sure that they were stored offsite and far away. Specifically, far enough away that a single disaster couldn’t affect both locations. There are a whole range of options for offsite backup storage, but one of my relatively recent favorites is in the cloud, and nowhere near my production databases. I’ve personally found storing my backups in the cloud to be convenient, reliable, and cost effective. With the availability of these services, there is absolutely no excuse not to have an off-site backup of your databases, assuming you don’t have any other available options.

Naturally, there’s a concern about security and privacy, but if you’re already sending your backup tapes offsite, you’ve already made that leap. And if our options are that, or lose our data completely, I guess we just have to go on trust.

Like any backup solution, I don’t put all of my eggs in one basket. I generally prefer to do local backups, then sweep the backups off individual SQL Servers to a central location, such as a NAS or SAN device at the local data center. Then, I have backups from these devices moved to the cloud. This way, if I need to do a restore quickly, I can get the most recent backup from the local device. But should a disaster destroy my data center, then I have an offsite backup I can use for restoring my SQL Servers.So, here’s my question for you. Do you have any experience storing SQL Server backups in the cloud, and if so, have they been positive or negative?

Total article views: 132 | Views in the last 30 days: 1
Related Articles

Offsite Backups

I have a client with a mission critical SQL Server serving local network and VPN users that wants of...


Cloud Common Sense

Moving to the cloud, or any other type of outsourcing should be done with common sense, as Steve dis...


Cloud backup - MS StorSimple Applicance

In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup d...


Cloud Safe

DR should always be on our mind, especially in the cloud.


Cloud Backup - Directly to Azure

Backup is one of the major task for DBAs, it has many different options and ways for each companies ...