Backup Aborted As Creation Of Virtual Device Set Failed – MSSQL Backup

Backup Aborted As Creation Of Virtual Device Set Failed – MSSQL Backup

KB ID : 100
Cause
MSSQL backup failed due to Virtual Device set creation failing issue.
Solution
Step 1:
  1. The SQLVDI.DLL not registered properly in the registry. To register the SQLVDI.DLL, you need to run the following command in run or in command prompt with administrator privileges (Right click runas administrator).
  2. For 32-bit., Regsvr32 “C:\Program Files\Microsoft SQL Server\80\COM\SQLVDI.DLL” – This is the default path.
  3. For 64-bit., Regsvr32 “C:\Program Files (x86)\Microsoft SQL Server\80\COM\SQLVDI.DLL”
For 64-bit
Step 2 :
OSQL utility path not set correctly in the system environment variables. Vembu client uses OSQL utility to backup the sql databases. The default OSQL path is “C:\Program Files\Microsoft SQL Server\90\Tools\Binn”.
To set the environmental variables, refer the steps mentioned below:
  1. Click START menu and right click on ‘My Computer’
  2. Select ‘Properties’

  1. Select ‘Advanced’ tab.
  2. Click on ‘Environment Variables’ button.

  1. Under “System Variables” section, if the “Path” variable does not exist, follow the steps below:
  1. Click ‘New’ button.
  2. Create the Path variable as follows:
  1. Variable Name: PATH
  2. Variable Value: C:\Program Files\Microsoft SQL Server\90\Tools\Binn

Step 3:
  1. Check the Vembu logon service user account is member of sysadmin. To check this follow the steps below in MSSQL management console.
  2. MGMT STUDIO —> Instance login —>Security—->logins–>click a particular user —> Server Roles and check the sysadmin option.
  3. Image resized, click image for full size.
Follow the steps below to add the OSQL.EXE path to environment variables:
  1. Click START menu and right click on ‘My Computer’
  2. Select ‘Properties’
  3. Select ‘Advanced’ tab.
  4. Click on ‘Environment Variables’ button.
  5. Under “System Variables” section, if the “Path” variable exists, click on “edit” button and append “C:\Program Files\Microsoft SQL Server\90\Tools\Binn” to “Variable Value”.
Step 4:
Check BDRSuite logon user has enough permission (administrator) to access the SQL databases.


    • Related Articles

    • SnapShot Creation Failed

      KB ID: 103020 Cause: The error message "SnapShot Creation Failed" typically occurs when the Volume Shadow Copy Service (VSS) writer status is unstable on the machine, preventing the creation of snapshots. Solution: To resolve the "SnapShot Creation ...
    • MSSQL Backup Failure: SQL Writer Failed

      KB ID: 113 Problem: When attempting to perform an MSSQL backup, users may encounter a failure with the error message "SQL Writer Failed." Cause: The "SQL Writer Failed" error can occur to various reasons, including: 1. VSS (Volume Shadow Copy ...
    • Backup aborted

      KB ID: 101005 Product: BDRSuite Backup Server Cause This will occur due to the following reasons: Backup configuration stored in the server and client is incompatible. When the Backup storage location is inaccessible to the backup server. If you ...
    • MAPI Profile Creation Failed

      KB ID: 111002 Cause: The 'MSPST MS' service is not configured, leading to the failure of MAPI profile creation. Solution: Follow the steps below to resolve the issue: 1. Create a New User: Create a new user with sufficient rights through Active ...
    • Changing Dump Location for MSSQL Backup

      KB ID: 115033 Cause: If you have configured MSSQL backup with a dump location and need to change it to another location, follow the steps below as it's currently not possible to change it through the web console. Solution: To change the default dump ...