Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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

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 Barriers

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


The Cloud

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


Training Center

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


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones