Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Lightbulb Unanswered: Failing database maintenance plan

    Hi there,

    I have a Database maintenance plan (DMP) that always fails!
    The plan reorganises data and index pages and checks database integrity.
    The plan covers several databases, and it always fails on the same database.

    The error message (in the DMP history) is the following: "[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has been disconnected. You must reconnect to perform this operation."

    The odd thing is that the DMP is locally executed, so I don't see why the network could be an issue here.

    Thank you for your time!

    gilles25

  2. #2
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163
    Not the network, could be memmory or cpu usage, also could be usage of the database (a user/connection) that never ends.
    Try to put the DB in administrative mode and then execute the MP for that particular DB.

    Paulo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •