question

pits avatar image
pits asked

corrupt_backup_files

Is there is any other way to identify corrupt files in backup apart from error logs? If we identify there is corrupt file in back up then we take a fresh backup.But if server fail before taking fresh back up,how we can deal with such situation? --- my add new comment button is not working hence updating comments here... Thank you Thomas, Yes,i am verifying backups as part of the backup process. I was referring to db fail,thanks --- Thank you Thomas for asking, I can seee the comment button,but when I click the same button there is no change in the screeen,I just see the same screen,no comment box appear where I can type in my comments.There is box at the bottom with the heading "your answer" but I think I can not type my comments in answer box. All together I could see in the link provided by you,that the same issue is faced by many of us and I need to earn some reputation i.e 10 points!!!I am not sure till the time I earn reputation how can I comment on my queries...strange!!! can you please assist? Rgds,
backupcorruption
1 comment
10 |1200

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

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Re: Comment button. By "not working" do you mean you get an error message? Or it's not there? or the text entry box doesn't appear when you click it? Or something else? There's just been a question about the UI - http://ask.sqlservercentral.com/questions/16021/meta-is-the-ui-difficult-to-navigate
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Are you verifying your backups as part of the backup process? Also, a routine test restore process would help to identify potential backup issues, and this is something that you should be doing anyway. See [Thomas LaRock's article on statistical sampling][1] for more information on improving your confidence levels that your backups are working as they should. In terms of recovering from a combination of corrupt backup and pooched database, well... "it depends". Is it the server that's failed, or the database itself, for example. [1]: http://thomaslarock.com/2010/05/statistical-sampling-for-verifying-database-backups/
10 |1200

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

WilliamD avatar image
WilliamD answered
When backing up, it is wise to test the backup by restoring it (on a test/dev system). Only after a successful restore is a backup file verified. I have heard a great statement before ***"You don't need a backup plan, you need a restore plan."*** A backup is worthless if you cannot restore it, so make sure that the entire process from backup to restore is verified. A good practice is to do a firedrill on a regular basis (at least once a year), where you simulate a disaster and go through the restore process. You then need to consider where your backups are stored: local disk, fileserver, tape. Is the final resting place also a safe storage location; the storage medium and the physical location (near a volcano?) The procedure for a restore will be different according to those factors and will affect downtime too. A local backup is quicker to restore than an offsite tape, but an offsite tape is better if your server-room burns to the ground. I would also like to mention that a backup is still only a copy of the database at a certain point in time. It is equally important for you to also perform regular integrity checks on your database(s) ([DBCC CHECKDB][1]). This can be done on the test/dev system that you perform the restore on, so that it doesn't affect your production system. And allows you to also test the repair process before doing so on the real system. [1]: http://msdn.microsoft.com/en-us/library/ms176064.aspx
2 comments
10 |1200

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 ·
Yep, verifying backups and testing backups. Those are your two options and you should be doing both, for multiple reasons.
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
+1 for regular CheckDB too. Although - caveat - -1 (career) if you don't do anything with the output from CheckDB.
1 Like 1 ·
SQLMaster avatar image
SQLMaster answered
10 |1200

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.