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 12»»

When is a Backup Considered Successful? Expand / Collapse
Author
Message
Posted Monday, June 8, 2009 12:18 AM
SSC Eights!

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

Group: General Forum Members
Last Login: Today @ 6:15 AM
Points: 914, Visits: 1,432
Comments posted to this topic are about the item When is a Backup Considered Successful?


Post #730487
Posted Monday, June 8, 2009 4:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 20, 2012 12:04 AM
Points: 91, Visits: 227
Hi
It is a really a good Article for the biginers as like me . and good ideas u have given


Regards
ksr
Post #730578
Posted Monday, June 8, 2009 5:36 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 15,737, Visits: 28,143
Good article.

You could have carried it a bit further. Including RESTORE VERIFYONLY as a part and parcel of your backup routines adds to the overall confidence you have in your backups. You also didn't mention getting consistency checks in place to run before full backups to ensure what's being backed up is more likely to restore.

Still, this is important information to get out to people and you made a good start. Well done.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #730603
Posted Monday, June 8, 2009 7:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
Good job mentioning the offsite tape testing. It's a good idea to get at least an annual test in the budget and make sure that the time to recovery doesn't increase over time. If it took 14 hours last year and takes 18 hours this year, then you need to analyze what happened in the chain... did someone forget where they had the contact information, were the restore instructions out-of-date because of server changes, etc.
Post #730673
Posted Monday, June 8, 2009 7:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 2,582, Visits: 3,836
Nice article. What good does a backup do if it can't be restored? None. A disaster is not the time to find your backup plan is useless.

I would also add figuring out the timings so you know how long it will take to get the tapes and do the restore. Let everyone know it so there are no expectations that can't be met. And, test it at the most inconvenient time to see how long it takes to get it from the offsite vendor.
Post #730674
Posted Monday, June 8, 2009 8:32 AM
SSC Eights!

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

Group: General Forum Members
Last Login: Today @ 6:15 AM
Points: 914, Visits: 1,432
Thanks for the value added comments. They're all worth appending into the article.


Post #730712
Posted Monday, June 8, 2009 9:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 12:08 PM
Points: 1,414, Visits: 4,540
there is a constant tape/disk battle here and i've used both. i'll take tape any day over disk.

in the last 9 years i've seen less than 5 tapes go bad over time. in the same time i've seen servers and disk systems die a lot more often. and with disk if the disk dies than all backups on the disk are gone.

we backup all of our SQL to tape via netbackup and the database agents. works very nice. for periodic restores we do them to QA and once in a while we call back tapes from offsite and restore them as well


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 #730737
Posted Monday, June 8, 2009 12:19 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: Wednesday, August 17, 2011 7:09 AM
Points: 869, Visits: 963
Also, it's usually a good idea to run DBCC CHECKDB after restoring databases from backups.
Post #730883
Posted Monday, June 8, 2009 12:50 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 12:08 PM
Points: 1,414, Visits: 4,540
not sure about native SQL backups, but with Netbackup you can do page verification during the backup and restore if you have it set up on the database

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 #730912
Posted Monday, June 8, 2009 1:22 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: Today @ 6:15 AM
Points: 914, Visits: 1,432
The RedGate backup will also validate the file.


Post #730932
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse