November 21, 2011 at 12:18 pm
Before you jump into restoring from a really old backup, try creating the database snapshot manually. If snapshot creation is successful, run CheckDB directly on the snapshot you created.
Let us know how that works out for you.
November 21, 2011 at 3:33 pm
Thanks Robert- I'll try and let you know results
November 30, 2011 at 12:51 pm
Have you fixed your problem? Or did you restore from a good .bak?
DBCC Checkdb with ALL_ERRORMSGS, NO_INFOMSGS, TABLOCK
I had similar problem and I used hint TABLOCK. Please try it and let us know your result.
November 30, 2011 at 4:34 pm
DBCC CHECKDB did not work for me with any argument. It's now out of my hand- I only investigated and reported.
I heard another DBA wanted to move this DB to another disk using detach/attach. I advised against it (as per Gail message and do not think it will solve the issue). Anyhow, cannot say more for now, sorry
November 30, 2011 at 4:41 pm
Did you attempt what I recommended? (create a snapshot manually and run DBCC CheckDB on the snapshot directly).
November 30, 2011 at 8:03 pm
Sorry Robert but honestly- not. This is production server and to make snapshot I need RFC, etc- long story. As I already mentioned it's out of my hand now but I did talked to another DBA regarding your offer. I'll double check again whether he tried this trick. Thanks
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply