Post reply

Optimizations and Integrity check jobs failing

  • February 26, 2010 at 10:12 am

    #138456

    Hi All,

    I have a maintenance plan for optimization and integrity check of databases. The jobs assigned for these two tasks are failing sometimes. I am getting the following error message:

    [Microsoft SQL-DMO (ODBC SQLSTATE: HY000)] Error 0: The server has been disconnected. You must reconnect to perform this operation.

    Can someone help me why the jobs are failing? Any suggestions?

    Thanks in advance,

  • February 26, 2010 at 11:05 am

    #1125729

    Any other messages?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 26, 2010 at 11:14 am

    #1125733

    No..That is the only message.

  • February 26, 2010 at 12:05 pm

    #1125771

    Try running the job step definition under SSMS manually and see if it gives you more detailed message.

    Also, try whts listed at-->http://qa.sqlservercentral.com/Forums/Topic117030-5-1.aspx#bm117428

    MJ

Viewing 4 posts - 1 through 3 (of 3 total)

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