[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 639
  • Last Modified:

Error in Backup

I have an SQL SERVER 2000 installed in a server.
I want to make a backup of my database.
Whenever I do this operation on any database even the pubs DB I get the following message:

Microsoft SQL-DMO(ODBC SQLState 42000)
Error 0: Cannot load the DLL xpstar dll, or one of the DLLs it references. Reason: 126(error not found).

but after I give the O.K. I get the message again but I manage to do the BACKup OK.
What does this message mean? Is it dangerous?
ThankYou
Anat
0
ANAT2403
Asked:
ANAT2403
1 Solution
 
bharatbutaniCommented:
Check your systems event viewer for errors.  Also you can access the errorlog file directly using any text editor.  This may show some information

Try going through this see if this helps ....

http://support.microsoft.com/default.aspx?scid=kb;en-us;827452



Regards
Bharat Butani.
0
 
SireesCommented:
xpstar.dll  should be installed in the d:\Program Files\Microsoft SQL Server\MSSQL\Binn folder. Chek if it is there.
0
 
ptjcbCommented:
What service pack have you installed? What version of MDAC?
0
 
TAB8Commented:
Install SQL SP4 this will update the .DLL in question
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now