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

Do You Verify Your Database Backups? Expand / Collapse
Author
Message
Posted Saturday, February 21, 2009 2:33 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
Comments posted to this topic are about the item Do You Verify Your Database Backups?

Brad M. McGehee
DBA
Post #662104
Posted Saturday, February 21, 2009 3:20 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:56 PM
Points: 35,404, Visits: 31,967
I absolutely agree... It's not what you can backup... it's what you can restore. I do at least one "practice" recovery a week and I'm not the System DBA. I do it because I'm pretty sure that they don't do it.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #662115
Posted Sunday, February 22, 2009 11:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:31 AM
Points: 2,909, Visits: 1,837
To be honest I am shocked to hear that people don't verify their backups.

I'm also surprised that it isn't the default action for a backup and requires a DBA to deselect it if they don't want to verify.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #662226
Posted Sunday, February 22, 2009 11:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 6:05 AM
Points: 40,258, Visits: 36,681
What backups?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #662227
Posted Sunday, February 22, 2009 11:35 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 6:05 AM
Points: 40,258, Visits: 36,681
David.Poole (2/22/2009)
To be honest I am shocked to hear that people don't verify their backups.

I'm also surprised that it isn't the default action for a backup and requires a DBA to deselect it if they don't want to verify.


What's worse is that, on 2000 and earlier, verify did very little. It checked the backup headers and a bit more. Passing verification was not a guarantee that the backup could be restored.
Even on 2005 and higher, I think you need to use the Checksum option for a verify check everything. Without that, the only way to check that a backup can be restored is to restore it.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #662228
Posted Sunday, February 22, 2009 6:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:13 PM
Points: 31,214, Visits: 15,660
In 2000 I checked it, but didn't count on it. I tended to restore often enough to dev/test that I didn't worry about scheduling things too much. We did have a quarterly test on some of the more critical systems to be sure that we could do it, and we'd pull back from tape at least yearly if not more often to be sure that things were working correctly.

I think it depends on your environment, but you want to both practice your skills at restoring (so restore logs, backups, and to times), and also make sure your equipment is working.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #662318
Posted Sunday, February 22, 2009 7:44 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 11:06 PM
Points: 599, Visits: 3,003
We're lucky. We don't have a true data warehouse so to provide reporting capabilities without impacting the OLTP we restore nightly the backups into the DW. The big thing missing though is the TLog and tape copies. The one time I tried to test the tape copies the tape was found to be corrupted!!!! I now just need to convince the system admin team (owners of the tape backups) that they need to put in place testing of the tapes. They say they have no room to test the recovery, I say a backup that cannot be recovered is not a backup. Discussions (arguments) continue ...


Post #662328
Posted Tuesday, February 24, 2009 12:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 9, 2012 8:29 AM
Points: 35, Visits: 31
We test them daily as they are transferred and restored to another server.
This another server is called "the clone".
Therefore anyone (testers, developers, ...) can do tests, simulation, analysis,... on the data of the production environment without touching it.

JM.
Post #663254
Posted Tuesday, February 24, 2009 3:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 8, 2013 5:39 PM
Points: 263, Visits: 862
We don't need no DBA 'round here checkin' our backups. We got that fancy Squeal Server that takes care of itself. Now git.


James Stover, McDBA
Post #663318
Posted Tuesday, February 24, 2009 6:08 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 2, 2013 1:16 PM
Points: 367, Visits: 303
The backup is not complete until I've restored it on a test machine. I know not everyone has this capability but since I've always been on small teams that were doing development as well as maintaining the production enviornment I have always had a "development" and "Test" machine and can not imagine relying on a backup that has not been tested.. The best axiom is "It isn't what you can backup, it's what you can restore".

James.
Post #663390
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse