December 23, 2008 at 10:53 pm
While taking the backup if the database is currupted what will we do?
December 23, 2008 at 11:28 pm
Lee - Is this a "what if" question or did this really happen? If you are concerned that you may have a corrupted database and that the database backup you are creating is thereby corrupted as well, that certainly is a possibility. You should make sure that you are running DBCC Checkdb with no_infomsgs, all_errormsgs (check the syntax in BOL) on a regular basis to ensure that your database is not corrupt. If it is not then your backup should be ok.
Please post with more information if I misunderstood the question or if you require any additional information.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 24, 2008 at 1:11 am
Lee From Bangalore (12/23/2008)
While taking the backup if the database is currupted what will we do?
Depending on the severity, fix the corruption, or restore a clean backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply