Daniel Britten (11/1/2010)
To be clean I am running DBCC CHECKDB ('database name', noindex) WITH PHYSICAL ONLY.
Bear in mind that those options will miss a lot of errors. You should be doing a full checkDB somewhere (restore backup on secondary server and run there perhaps)
As I said before this started with on database have an issue, I was able to delete it, now I have the same issue with another database. I have also tried to detach the database, drop the database, and backup the database. All fail. I can query the data with no problem. It is as if any time SQL needs to talk to the OS about this database, it locks up.
Any errors in the SQL error log? Any errors in the windows event log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability