<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Pavel Bondarchuk
»
Backup SQL Server to Amazon S3 with...
Backup SQL Server to Amazon S3 with CloudBerry Backup
Rate Topic
Display Mode
Topic Options
Author
Message
andy-1011296
andy-1011296
Posted Thursday, May 13, 2010 12:01 AM
Forum 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
alen teplitsky
alen teplitsky
Posted Thursday, May 13, 2010 6:50 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411,
Visits: 4,517
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
SQLRNNR
SQLRNNR
Posted Thursday, May 13, 2010 11:57 AM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:09 PM
Points: 18,848,
Visits: 12,433
Nice informative article. Thanks for sharing.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #921529
Charles Kincaid
Charles Kincaid
Posted Thursday, May 13, 2010 4:39 PM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 11:56 AM
Points: 772,
Visits: 1,828
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
Charles Kincaid
Charles Kincaid
Posted Thursday, May 13, 2010 4:50 PM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 11:56 AM
Points: 772,
Visits: 1,828
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
alen teplitsky
alen teplitsky
Posted Friday, May 14, 2010 7:12 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411,
Visits: 4,517
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
AlexGreen
AlexGreen
Posted Wednesday, May 23, 2012 2:59 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, February 05, 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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
