SQL Back UP Error ( ODBC SQL STATE : 4200)

  • Hi To all SQL Administrator,

    I am asking your much needed help regarding SQL 2000, I encounter this problem during back-up. My Error Say's

    ODBC SQL State :4200

    Error 0: Can not load DLL xpstar.dll or one the dll it reference reason 126.(The specified module could not be found)

     

    Odie

     

     

     

     

     

     

  • Are you running the backup from a maintenance plan ? If you are not using a maintenance plan, is the Job executed via the SQL Agent ? If it is executed via the SQL Agent, can you cut out the SQL and execute it in a QA window ? Also, did the error message you posted get truncated ? I'm thinking the error number might be 42000 - bad username/password ???

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • To Rudy Komcsar,

        This error occurs from Enterprise Manager during Backup process, So I cant backup database from my SQL Server right now.

     

  • Can you execute a TSQL backup command from QA ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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