June 24, 2019 at 12:50 pm
Team,
If DBCC CHECKDB is successful; do we still need to perform Verify Backup Integrity while taking the DB Backups.
As far as i believe; if DBCC CHECKDB is successful then it means that the Database is free from any sort of corruption. In that case; there shouldn't be a need to perform Verify Backup Integrity.
Please Advise.
With Thanks,
S
June 24, 2019 at 1:13 pm
Not so. DBCC CHECKDB verifies that the database is free from corruption, as you say. Verifying the backup performs a check on the backup file. It's possible to have a bad backup of a good database. That said, the RESTORE VERIFYONLY check only checks the backup header, if I remember correctly, so even if it comes back clean, it doesn't mean you have a good backup. The only way to be completely sure is to restore the backup.
John
June 24, 2019 at 3:15 pm
John is correct. They are two different things.
DBCC CHECKDB, depending upon the parameters passed into it, only checks for corruption within the database.
RESTORE VERIFYONLY only checks to see if the backup can be restored. It does not look for corruption in the database.
Again, to repeat what John said, the only way to be 100% certain that a backup is good is to restore it.
You can perform a good backup, and a good restore, of a corrupted database.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 10, 2019 at 7:31 pm
How about running DBCC (only) on the RESTORED database and killing three birds with one stone?
July 11, 2019 at 4:02 pm
Frank you can definitely do that. We used to do that on a nightmare sharepoint site collection database that grew to about 3 Tb for a client. The DB grew out of control, then the client started only doing log backups and then finally called us when it become even more serious. Whenever we could, we would restore it and several hundred (or maybe several thousand?) log backups on a spare junker server then run a checkdb. The process would take a few days to complete but gave us the confidence to start messing with it and fix the problem.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply