September 12, 2009 at 3:24 am
when I execute DBCC CHECKDB
sql server returns
CHECKDB found 0 allocation errors and 2 consistency errors in database 'sbli9'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDatabase ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Please advise how to deal with this issue
best regards
Shen
September 12, 2009 at 9:47 am
Can you post the actual errors that it found too please?
Btw, you're running SQL 2000 (as I removed the repair_fast statements from the output in 2005). Please be aware that there's a separate forum for 7.0 and 2000 corruptions, as the errors and resolutions are often different. It's important to get things right when dealing with corruption.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply