What are the challenges you face when working across database platforms? Take the survey
Options

SQLBackupAgent will not start.

gottfoogottfoo Posts: 8
edited June 6, 2007 2:04PM in SQL Backup Previous Versions
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?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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).
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    That did the trick. Thanks.
Sign In or Register to comment.