VDI error 1000: Failed to create virtual device

joshsackett

Hi all,
I've scanned other topics but have been unable to find a resolution to my problem.

Environment:
Windows 2000 Advanced Server
SQL Server 2000 Standard Edition
Server name = P245SQL02
SQL instance name = P245SQLI02
SQL Backup v5.1.0.2781

When running a full database backup through either the GUI or QA I receive the error:

VDI error 1000: Failed to create virtual device. Check that the SQL Server instance you are trying to connect to is running. Error code: (-2139684857: Failed to recognize the SQL Server instance name.)

petey

If you were to use the command line interface, does the backup succeed ? E.g.

sqlbackupc -sql "BACKUP DATABASE model TO DISK = 'c:\model.sqb' " -i P245SQLI02

Note that you need to run this on the server itself. Thanks.

joshsackett

Yes, that worked correctly.

petey

When connected to the P245SQLI02 instance using QA, does running the following create a backup?

EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT" '

Thanks.

joshsackett

No, same error as above.

petey

I have sent you a private message with instructions on how to log the SQL Backup Agents' internal processes. Could you pls send me the resulting log? Thanks.

joshsackett

The solution:

I do not run the service under LocalSystem, I had created another Windows authenticated user (with domain privileges) as I copy the database backup to a shared folder on the network.

I had to go in and add this user to the Administrators group on the server.