Unable to backup SQL 2k databases with SQL agent, unknown error

[SNtech 0]

Hello,

 

Here are the stats:

I am using Retrospect 6.5 (v6.5.350) multi-server with SQL agent and Open File agent on Windows 2000 Server w/ SP4.

 

The SQL server machine has been upgraded from Windows 2000 server to Windows 2003 Server without SP1.

SQL server is MS SQL 2000 w/SP4.

Retrospect Client version: 6.5.136

Share Point services (not Portal) has been installed on this machine as well. It is using the MS SQL database, not MSDE.

 

During the backup process, I am able to backup the drive data on the server, but not the SQL databases. This is the error I receive:

Trouble reading files, error -2147221164 (unknown)

I receive this error for each database.

The Retrospect SQL agent is using local admin to access the SQL server.

 

Well, that error number doesn't exists anywhere.

 

Here is what I tried so far:

Remove the SQL agent and client from the SQL server.

Reinstall the Backup client and SQL agent.

Tried to backup just one database, not the whole server or all databases, still receive the same error.

Rebooted both machines, as well. (hey, it works for 99.9% of Windows issues)

The SQL server was upgraded to Windows 2003 to be able to use Sharepoint services and during the course of the upgrade SQL server needed to be updated to SP4.

The Retrospect backup was working after this upgrade/update.

 

This error just started to happen a few days ago. There were no additional updates done to the machine.

 

Please let me know if there is a way to troubleshoot/resolve this issue.

 

Thank You,

 

Christopher Massa

[natew 0]

Hi

 

"unknown" errors mean that Retrospect does not know what the problem is. It tried to send backup commands to the database but all it got back was the error message.

 

google brought up a few articles about this error:

http://community.borland.com/article/0,1410,19664,0.html

 

I'm not sure if the causes are the same but it is worth looking into.

 

Thanks

Nate

[SNtech 0]

Hello,

 

I just wanted to send a followup with regards to this issue.

 

I was able to resolve it, thanks to everyone's help. I looked into the error message on google and on the posts here.

 

It turns out is was an unregistered DLL on the SQL server machine.

 

C:\Program Files\Microsoft SQLServer\80\COM

 

I found a MS KB that pointed to the suspected dll:

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

 

Although the KB refers to the issue of having v7 and v2000 on the same machine, which was not the case with me, it did give me the pointer.

 

After I registered "sqlvdi.dll", the backup process was able to work against the SQL databases.

 

Christopher Massa

[today 0]

THANK YOU THANK YOU THANK YOU THANK YOU

 

This totally worked for me.

 

For others, here's the actual command

regsvr32 sqlvdi.dll

 

and I did it in this directory

C:\Program Files\Microsoft SQL Server\80\COM