question

cstephen avatar image
cstephen asked

how to check db bakup is corrupted or not without restoring the .bak file in ssms

I am having the back up of my production server scmdb.bak. before restoring the database back up in sql server management studio.is there any way to check my database bakup condition either corrupted or in good condition.
sql-server-2008backup-restore
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
ThomasRushton avatar image
ThomasRushton answered
Our very own @Grant Fritchey explains the process well in the first video on this page: http://www.red-gate.com/products/dba/sql-backup/version-7/ - the video entitled "Verify your backups". In short, the only way to truly verify that your backup is in good condition is to restore it. This is one of the things a DR environment can be used for - continually making sure that your backups restore correctly.
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
The video might be a little over the top. Here's an article that summarizes the importance of database testing: http://www.simple-talk.com/sql/backup-and-recovery/backup-verification-tips-for-database-backup-testing/
3 Likes 3 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@Grant - I think you were holding back in that video...
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Absolutely! You should hear what I really think.
0 Likes 0 ·
jason_clark03 avatar image
jason_clark03 answered

you can use powershell script to verify backup files. see here: https://www.sqlservercentral.com/blogs/use-powershell-script-to-verify-backup-files

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.