Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I know I can execute a DBCC CHECKDB and get a status of my database.

Questions

  • How can I find if there is some corrupt data page into my database?
  • If an error is throwndue to page corruption, where can I find which pages are corrupt?
  • How can can I find out the page number of each corrupt page.

Can anybody can tell me where to find those page ids ?

share|improve this question
    
I think that i found the table where the corrupt page id are stored. Can it be 'suspect_pages' of the MSDB database ? –  Nico Mar 17 '11 at 0:31
    
yes there is a possiblity to have a msdb database corrupted pages. MSDB stores info about backups, restores, all jobs info. If SQL is forcebly stopped or another failure event occurs when a backup, restore or job is changing the data of some page - then this page can become corrupted. –  yrushka Mar 22 '11 at 16:16
add comment

1 Answer

up vote 11 down vote accepted

Yes, there is a suspect_pages table.

Here is more good info on DBCC CHECKDB http://blogs.msdn.com/b/cindygross/archive/2010/06/13/dbcc-checkdb-database-integrity.aspx

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.