How to find corrupt page in SQL Server 2008 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 ?
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