snippetModerate
How to find corrupt page in SQL Server 2008
Viewed 0 times
how2008corruptsqlpagefindserver
Problem
I know I can execute a
Questions
Can anybody can tell me where to find those page ids ?
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 ?
Solution
Yes, there is a suspect_pages table.
Here is more good info on DBCC CHECKDB Link
Here is more good info on DBCC CHECKDB Link
Context
StackExchange Database Administrators Q#1785, answer score: 11
Revisions (0)
No revisions yet.