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

Maintenance Plan freezes on Check Database Integrity Expand / Collapse
Author
Message
Posted Wednesday, March 17, 2010 5:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:29 PM
Points: 2, Visits: 30
I am running a maintenance plan on a 128 gb database in sql 2005.

I crated a maintenance plan with the tasks in this order

Check Database Integrity
Reorganize Index
Update Statistics
Back Up Database (Full)

It is still running after 10 hours with this error

Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Post #885144
Posted Wednesday, March 17, 2010 6:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:29 PM
Points: 2, Visits: 30
Also I am able to run it dbcc checkdb from query window but stops or freezes in the plan
Post #885145
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse