Can not backup or restore SQL server

4 May 2006 7:46 PM

jeffzhang44@gmail.com

The sql server was working fine.

Since yesterday, can not back up or restore at all.

Error message is:

Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it
references. Reason: 126(The specified module could not be found.)

Checked the file is there, Error log did not show anything.

Running Windows SBE 2003, SQL server 2000 SP3

Can any one help? Thanks in advance

4 May 2006 10:19 PM

Erland Sommarskog

jeffzhan***@gmail.com (jeffzhan***@gmail.com) writes:

> The sql server was working fine.
>
> Since yesterday, can not back up or restore at all.
>
> Error message is:
>
> Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it
> references. Reason: 126(The specified module could not be found.)
>
> Checked the file is there, Error log did not show anything.

Could be a DLL that xpstar is referring to. I'm looking at what
DLLs xpstar has dependencies to, and among them is MSVCR71, the
C run-library for C++ for Visual C++ 7.1. This file does not come
with the OS. But I should add that I have SP4, and the SP3 file
could have different dependencies.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

5 May 2006 2:47 PM

jeff

How could I check the dependencies? Thanks for the help.

5 May 2006 3:43 PM

Tibor Karaszi

Here's one option: http://www.snapfiles.com/get/dependencywalker.html

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"jeff" <jeffzhan***@gmail.com> wrote in message
news:1146840454.129849.212440@i40g2000cwc.googlegroups.com...
> How could I check the dependencies? Thanks for the help.
>