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

Checking Backup Files Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 6:56 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 7:03 AM
Points: 158, Visits: 239
Hello,

Having read an article about restoring from your backups and the things you can do to minimize potential problems therein, I saw the following command:

RESTORE HEADERONLY ....

This was suggested as a way of testing the header(s) in your backup file.

I also came across the following:

RESTORE VERIFYONLY ...

Which I think, from memory, stated that it was the closest thing to actually recovering without doing so.

Does anyone have views as to which of the above is best?

Regards

Steve
Post #1395646
Posted Wednesday, December 12, 2012 7:14 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 01, 2013 10:17 AM
Points: 323, Visits: 984
Hi Steve,

Restore Verifyonly
will tell you whether backup file is valid or not ,so no doubt its best option to check whether your backup files are restorable or not and always recommended to verify your backup files after backup operation


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1395657
Posted Wednesday, December 12, 2012 7:19 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
There's only 1 valid test.

FULL restore, including diffs and logs.

THEN run checkDB.


Now you know you're good.

Once that's done you can't move the files because they could get corrupted in the transfer. Of course it could still happen sittin on the disk. So yes, if you can, retest old backups every once in a while.
Post #1395659
Posted Wednesday, December 12, 2012 7:23 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 7:03 AM
Points: 158, Visits: 239
Ninja's_RGR'us (12/12/2012)
There's only 1 valid test.

FULL restore, including diffs and logs.

THEN run checkDB.


Now you know you're good.

Once that's done you can't move the files because they could get corrupted in the transfer. Of course it could still happen sittin on the disk. So yes, if you can, retest old backups every once in a while.


Granted.

But, if you can't actually restore, then what's the next best thing?
Post #1395664
Posted Thursday, December 13, 2012 1:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 6:32 AM
Points: 221, Visits: 1,690
raotor (12/12/2012)
Ninja's_RGR'us (12/12/2012)
There's only 1 valid test.

FULL restore, including diffs and logs.

THEN run checkDB.


Now you know you're good.

Once that's done you can't move the files because they could get corrupted in the transfer. Of course it could still happen sittin on the disk. So yes, if you can, retest old backups every once in a while.


Granted.

But, if you can't actually restore, then what's the next best thing?


Then use checksum:

BACKUP DATABASE test
TO DISK = 'd:\test_checksum.bak'
WITH CHECKSUM, INIT;

RESTORE VERIFYONLY
From disk = 'd:\test_checksum.bak'
WITH CHECKSUM

Post #1396047
Posted Thursday, December 13, 2012 1:46 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 7:03 AM
Points: 158, Visits: 239
*** it happens, I already use CHECKSUM. I also run a DBCC CHECKDB on the database before being backed up ensuring that should that fail that the backup is not done and an alert is raised.

Hopefully, all these measures will increase the chances of a successful restore should I need it.

Post #1396052
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse