kfk (9/1/2010)
According to Microsoft, REPAIR_REBUILD "Performs repairs that have no possibility of data loss".
Correct, but you should still not be running that to check for errors. To just check for errors run the following:
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
What's the SQL instance's max and min memory set to?
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