March 22, 2011 at 3:28 am
I ran DBCC CheckDB and reports consistency errors.Is the a command that I can use to fix the errors.
Regards,
S.K DBA
March 22, 2011 at 4:45 am
Please run the following and post the full and complete results. Without seeing the errors I can't recommend a route to fix.
DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS
This may be worth a read - http://www.sqlservercentral.com/articles/Corruption/65804/
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
March 23, 2011 at 6:14 am
There are many different reasons and types of errors/messages that come out of a failed DBCC CHECKDB. You must research the specific error and post it here and we will attempt to help.
March 24, 2011 at 7:45 am
you should NOT be looking to solve consistency errors from a forum thread. There are SOOOO many variables here and ways you can go disasterously wrong. PLEASE get a qualified person on the phone or remoting in to help you figure out what is really going on and how to best solve the problem.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 24, 2011 at 7:47 am
I'd take Gail's forum advice any day...
March 24, 2011 at 8:47 am
Ninja's_RGR'us (3/24/2011)
I'd take Gail's forum advice any day...
So would I, but I would not be looking to deal with dbcc checkdb issues on a forum - even sqlskills.com. I would get Paul on the phone or remoted into my system instead.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply