sierra4 (8/29/2012)
i have not used the dbcc repair options before, but in this regard is the experts' recommendation to use dbcc repair only as a last resort?
In most cases, yes. It loses data
i will recreate the indexes next.
Gut feel, that's not going to work here, but I would like a checkDB output without the info messages to confirm.
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