Monday, February 20, 2012

maintenance plan stops with a xpstar.dll is missing msg

Hi,

I used to have a maintenance plan for my database, I just realized that the backup wasn't taken for more than 2 weeks . and when ever i try to view the Jobs or the maintenance plan i get this error msg : cannot load the DLL xpstar.dll, reason126:(the specified moudle could not be found).

I looked under the Bin directory and couldn't find the xpstar.dll file and i'm sure i didn't delete it .so what should i do ? could i just copy paste the file or i need to reinstall the SQL ?

Can you check whether SQLAgent has been started correctly, also confirm what account has been used to start SQLAgent service.

It seems the XPSTAR.DLL is missing and try to find the file from any other location in the server, if not try to copy from another machine which is similar to this installation.

|||

I copied the file and it worked :)

Thank you.

No comments:

Post a Comment