Maintenance Plan freezes on Check Database Integrity

  • 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.

  • Also I am able to run it dbcc checkdb from query window but stops or freezes in the plan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply