VDI error 1000: Failed to create virtual device

• 
  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.

  petey July 04, 2007 02:05

  - 0 +
• 
  Yes, that worked correctly.

  joshsackett July 10, 2007 09:31

  - 0 +
• 
  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.

  petey July 10, 2007 10:08

  - 0 +
• 
  No, same error as above.

  joshsackett July 10, 2007 11:48

  - 0 +
• 
  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.

  petey July 10, 2007 12:27

  - 0 +
• 
  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.

  joshsackett July 20, 2007 11:55

  - 0 +

Add comment

Please sign in to leave a comment.