Sunday, April 3, 2011

DBCC CheckDB WITH PHYSICAL_ONLY hangs at 99.3%

So after recovering a bunch of SharePoint MDF files from a SAN that went south due to client configuration idiocy we are now at the point where we are trying to reconnect the SQL databases. There were a handful of small databases that we recovered that mounted with no issues however the important database that holds an entire document management system is around 500gb and once we reconnected that database it came up in SQL server as "Suspect". I read online and tried the usual steps of placing the database in emergency mode then running DBCC CheckDB on it. That operation never finished after 12 hours and when i looked at the activity on it it seems to have hung.

Today I ran DBCC CheckDB WITH PHYSICAL_ONLY and it also hung at 99.3% completion after an hour. We are going to open a ticket with MS support but just wondering what other steps I can take at this point? BTW I am able to query the database in single user mode and see our data and image binaries.

From stackoverflow

0 comments:

Post a Comment