rspskumar-704119 (1/17/2010)
plese set db status to emerngy mode and export data and run repair
Absolutely not. Totally unnecessary and frankly in this case stupid things to suggest.
Emergency mode is a last resort for when the database is in suspect or recovery pending mode. Not for when the database is online and usable with minor corruption.
Export (and subsequent re-import) is for when there's irreparable corruption, like damaged allocation pages. This corruption is perfectly repairable (albeit with minor data loss) and hence there is no need whatsoever for something as extreme as export and reimport.
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