Click here to monitor SSC
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: 129 | Views in the last 30 days: 1
 
Related Articles
FORUM

Offsite Backups

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

ARTICLE

Cloud Common Sense

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

ARTICLE

Cloud Barriers

I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of movin...

BLOG

Training Center

We kind of opened the training center today. The pages are up, Google's charging us for their nice A...

ARTICLE

The Cloud

Steve Jones likes the Cloud and gives a few reasons why. He also thinks we'll see more data in the c...

Tags
 
Contribute