SQLBackupAgent will not start.

gottfoo

After a reboot of our sql server the SQLBackupAgent will no longer start. The event log shows "SQL Backup Agent startup error: VDI library not registered." with an event ID of 660. Any ideas how to fix this?

petey

SQL Backup uses a SQL Server COM library in order to perform the backup/restore operations. This COM library is contained in a file named sqlvdi.dll, and is installed together with SQL Server. This file is usually not uninstalled when you have existing SQL Server installations, but exceptions do happen.

It appears that the library is no longer installed on your system. You can confirm this by checking for the GUID key '{40700425-0080-11d2-851f-00c04fc21759}' in the registry, under HKEY_CLASSES_ROOT\CLSID.

If this key was not found, you need to register the library manually. Look for sqlvdi.dll on your system, and ensure that you have the file for the latest version of SQL Server installed on your system (i.e. if you have both SQL 2000 and SQL 2005 installed, you must use the sqlvdi.dll installed with SQL 2005). Also note that if you are running on a 64-bit system, you need to register both the 32-bit and 64-bit versions.

Once you have found a suitable file, register it manually e.g.

regsvr32 sqlvdi.dll

and check that the registry now contains the above key, for all relevant bitness (32/64).

gottfoo

That did the trick. Thanks.