Jump to content
Sign in to follow this  
lafong

Can't backup SQL DB's

Recommended Posts

I have not been able to backup the databases in our SQL 2000 server. I get this error for each database:

Trouble reading files, error -2147221164 (unknown)

 

I don't find this error listed anywhere in the forums or FAQ's. I have a retrospect user, who is an administrator, on the SQL server. In Retrospect, I can browse the databases just fine. I have manually tried a full backup. I can preview the data in the manual backup fine. Just get this same error every time.

Share this post


Link to post
Share on other sites

Are you able to use the SQL backup tools built into SQL Admin without getting any errors?

 

Google the error 2147221164

 

You will see some general SQL errors for that error code.

Share this post


Link to post
Share on other sites

>Are you able to use the SQL backup tools built into SQL Admin without getting any errors?

 

Yes

 

>Google the error 2147221164

>

>You will see some general SQL errors for that error code.

 

I did. Seems to be several suggestions, from JET to COM to ADSI to Office reinstall. There was a JET update available, which I installed, registered the DLL, no help. The SQL log shows the retrospect user logging in as a trusted user. We are running Project client on the server too, for remote access.

Share this post


Link to post
Share on other sites

Seem to have fixed it. I had tried re-registering a few dlls individually, no help. When I re-registered all dlls in C:\Program Files\Microsoft SQL Server\80\COM at once, it worked.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×