Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

error# 625 Expand / Collapse
Author
Message
Posted Saturday, September 12, 2009 3:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 14, 2009 11:51 PM
Points: 1, Visits: 4
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
Post #786841
Posted Saturday, September 12, 2009 9:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:15 AM
Points: 2,041, Visits: 1,671
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
Post #786884
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse