Backup SQL Server to Amazon S3 with CloudBerry Backup

Question

Backup SQL Server to Amazon S3 with CloudBerry Backup

andy-1011296

SSC Journeyman

Points: 81
More actions
May 13, 2010 at 12:02 am

#222501

Comments posted to this topic are about the item Backup SQL Server to Amazon S3 with CloudBerry Backup

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 1

i haven't done the cost analysis, but for a medium to larger environment i think tape and local onsite backups are cheaper. LTO-4 tape is dirt cheap and the big investment is the robot and backup software

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Nice informative article. Thanks for sharing.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Charles Kincaid SSChampion Points: 13593 More actions · Answer 3

alen teplitsky (5/13/2010)
i haven't done the cost analysis, but for a medium to larger environment i think tape and local onsite backups are cheaper. LTO-4 tape is dirt cheap and the big investment is the robot and backup software

It will be cheaper. Well you have to invest in the hardware. Then there is the time it takes to set it up and configure it properly. Those are all up front costs and you can amortize those over time. Then buy as many tapes as you want. They last a long time and you will want as many as you can handle and afford.

There is one word, though, that is key to what you say. That word is onsite. If you are going to use tapes, and I am not saying that you should not use them, then at least put some kind of strictly enforced off site rotation plan into place.

Talk to someone who has has a building fire, flood, storm damage, or earthquake

ATBCharles Kincaid

Charles Kincaid SSChampion Points: 13593 More actions · Answer 4

andy-1011296 (5/13/2010)
Comments posted to this topic are about the item <A HREF="/articles/Backup/70242/">Backup SQL Server to Amazon S3 with CloudBerry Backup</A>

Nice article. Well done.

I was wondering how this stacks up against services like Carbonite Pro[/url] or Barracuda Backup Service.

Also I've seen practices where one uses SQL Server backup to make .bak files and then off-site backup those. How does that compare to what you are doing?

Thanks again for being a brave pioneer and a good writer.

ATBCharles Kincaid

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 5

Charles Kincaid (5/13/2010)
alen teplitsky (5/13/2010)
i haven't done the cost analysis, but for a medium to larger environment i think tape and local onsite backups are cheaper. LTO-4 tape is dirt cheap and the big investment is the robot and backup software
It will be cheaper. Well you have to invest in the hardware. Then there is the time it takes to set it up and configure it properly. Those are all up front costs and you can amortize those over time. Then buy as many tapes as you want. They last a long time and you will want as many as you can handle and afford.
There is one word, though, that is key to what you say. That word is onsite. If you are going to use tapes, and I am not saying that you should not use them, then at least put some kind of strictly enforced off site rotation plan into place.
Talk to someone who has has a building fire, flood, storm damage, or earthquake

did some quick math and with 100 LTO tapes that i have in my robot now at 2TB per tape i get $30,000 per month just for the storage cost. the transfer costs are extra.

our investment has been less than $40,000 so far for the robot, software, tapes and a few other extras we had to buy along the way over the last year. we just bought 20 LTO-4 tapes for $778. that's 20-60 TB of data we can store depending on the compression

AlexGreen Right there with Babe Points: 763 More actions · Answer 6

CloudBerry seems like a nice product, but adjusting it to SQL Server backups seems a bit convoluted. SQLBackupAndFTP allows you to do backups to Amazon S3 in a much simpler manner - just look at a screenshot from this post: http://pranas.net/2012/05/sql-backup-to-amazon-s3[/url]