in More Search Options

database maintenance failing

Last post 08-22-2007 1:25 PM by cori. 5 replies.
Page 1 of 1 (6 items)
Sort Posts:
  • 08-21-2007 1:49 PM

    • cori
    • Not Ranked
    • Joined on 08-21-2007
    • middleton, wi, us
    • Posts 5
    • Points 11

    database maintenance failing

    The nightly database maintenance job on our installation of Orion (8.1.0, on a virtual 64-bit sql server instance) consistently fails on the rebuild indexes step.  The message in the job log is:

    "[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has been disconnected. You must reconnect to perform this operation."

    Running a copy of the job without the index rebuilding step runs seccessfully every time.

    ----
    Thanks;
    cori
    • Post Points: 3
  • 08-22-2007 8:45 AM In reply to

    • Ishikawa
    • Top 75 Contributor
    • Joined on 05-16-2007
    • Dallas, TX
    • Posts 78
    • Points 184
    • SolarWinds Employee

    Re: database maintenance failing

    I have not seen that on my own systems. You may want to engage Solarwinds support to look deeper into that error.

    Cheers,

     

    Dan Wendeln
    Sr. Field Application Engineer
    SolarWinds
    • Post Points: 3
  • 08-22-2007 9:30 AM In reply to

    • anselm
    • Top 150 Contributor
    • Joined on 06-05-2007
    • Berlin
    • Posts 49
    • Points 103

    Re: database maintenance failing

     Cori- any other erros in the file like a syntax error?

     http://thwack.com/forums/p/4654/20153.aspx#20153


     

    • Post Points: 3
  • 08-22-2007 9:38 AM In reply to

    • cori
    • Not Ranked
    • Joined on 08-21-2007
    • middleton, wi, us
    • Posts 5
    • Points 11

    Re: database maintenance failing

    I should have mentioned that I already applied that patch.  No other errors that I can see.

    ----
    Thanks;
    cori
    • Post Points: 3
  • 08-22-2007 11:08 AM In reply to

    Re: database maintenance failing

    You should definitely open a Support ticket.

    Denny LeCompte
    Sr. Product Manager, Orion
    SolarWinds
    Austin, TX
    • Post Points: 3
  • 08-22-2007 1:25 PM In reply to

    • cori
    • Not Ranked
    • Joined on 08-21-2007
    • middleton, wi, us
    • Posts 5
    • Points 11

    Re: database maintenance failing

    OK, thanks.  will do.

    ----
    Thanks;
    cori
    • Post Points: 1
Page 1 of 1 (6 items)