dbcc checkdb returns errors and then what? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

dbcc checkdb returns errors and then what?

When I run dbcc checkdb on a database, it found some allocation errors and some consistenecy errors. One of the allocation errors is error 8946 Level 16 State 12 PFS_PAGE. How should I correct these errors? Thanks.
You can use REPAIR_FAST or REPAIR_REBUILD options. Check BOL for details. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
]]>