Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup SQL Server to Amazon S3 with CloudBerry Backup Expand / Collapse
Author
Message
Posted Thursday, May 13, 2010 12:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 11:11 PM
Points: 1, Visits: 5
Comments posted to this topic are about the item Backup SQL Server to Amazon S3 with CloudBerry Backup
Post #921006
Posted Thursday, May 13, 2010 6:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 10, 2014 9:36 AM
Points: 1,414, Visits: 4,544
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

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #921204
Posted Thursday, May 13, 2010 11:57 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 17,966, Visits: 15,971
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
Post #921529
Posted Thursday, May 13, 2010 4:39 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 808, Visits: 1,994
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


ATB

Charles Kincaid

Post #921676
Posted Thursday, May 13, 2010 4:50 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 808, Visits: 1,994
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 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.


ATB

Charles Kincaid

Post #921680
Posted Friday, May 14, 2010 7:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 10, 2014 9:36 AM
Points: 1,414, Visits: 4,544
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


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #922006
Posted Wednesday, May 23, 2012 2:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 8:56 AM
Points: 17, Visits: 40
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
Post #1305389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse