KB ID : 100
Published : Jan. 28, 2016
Created : Jan. 28, 2016
Last Modified : Oct. 20, 2016

Cause

MSSQL backup failed due to Virtual Device set creation failing issue.

Solution

Step 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).

For 32-bit., Regsvr32 “C:\Program Files\Microsoft SQL Server\80\COM\SQLVDI.DLL” – This is the default path.

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’

    Select ‘Properties’

  3. Select ‘Advanced’ tab.

  4. Click on ‘Environment Variables’ button.

    ‘Environment Variables’

  5. Under “System Variables” section, if the “Path” variable does not exist, follow the steps below:

  • Click ‘New’ button.
  • Create the Path variable as follows:

    1. Variable Name: PATH

    2. Variable Value: C:\Program Files\Microsoft SQL Server\90\Tools\Binn

 Variable Value: C:\Program Files\Microsoft SQL Server\90\Tools\Binn

Step 3:

Check the Vembu logon service user account is member of sysadmin. To check this follow the steps below in MSSQL management console.

MGMT STUDIO —> Instance login —>Security—->logins–>click a particular user —> Server Roles and check the sysadmin option.

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 vembu logon user has enough permission (administrator) to access the SQL databases.

edit retag flag offensive close merge delete