June 15, 2010 at 8:21 am
Hi to all
What exactly happens if we find any torn page in database ?
June 15, 2010 at 8:30 am
Find a torn page or cause a torn page?
When SQL finds a torn page it will throw a severity 24 error and log the page into the suspect pages table in MSDB. That's all that's certain to happen. Depending on what the page is other things can happen afterwards.
Why are you asking? Just academic?
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
June 15, 2010 at 9:13 am
No, actually one of interviewer asked me this question. And how can we resolve this torn page issue can we resolve this by using existing backup or do we need some live operations ?
June 15, 2010 at 10:57 am
Have a look through this: http://www.sqlservercentral.com/articles/Corruption/65804/
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply