I'm getting this 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: (-2147024891: )

I was running sqlbackupc to restore a DB from backup. Anything I miss?

Saw some forum topics, but those are 4 years old.
adriangodong
0

Comments

6 comments

  • Brian Donahue
    Hi,

    I would imagine any four-year-old information about VDI is just as well because the API hasn't changed all that much. However, you should probably check the Red Gate support center as well, because the information there is collated, researched, verified, and kept up-to-date.

    VDI 1000 caused by bad installation:
    http://www.red-gate.com/supportcenter/C ... 000241.htm
    VDI 1000 caused by permissions
    http://www.red-gate.com/supportcenter/C ... 000243.htm
    VDI 1000 caused by account lookup failure
    http://www.red-gate.com/supportcenter/C ... 000242.htm

    There could be many more causes. Basically VDI 1000 is a generic failure in creating the virtual backup device on the SQL Server end.
    Brian Donahue
    0
  • adriangodong
    Are those related to the GUI version as well?

    I can restore with GUI, but I'm considering moving to automatic restore via the console app.

    The error happened on the console app.

    I am using the parameters copied from the last step from the GUI.
    adriangodong
    0
  • Brian Donahue
    Are you running the backup command from a different computer? If your windows logon doesn't have the permissions, you may want to try SQL authentication. (-u and -p arguments).

    You could also use sqlcmd.exe to execute the stored procedure-formatted command and see if you get better results that way.
    Brian Donahue
    0
  • adriangodong
    We're using SQL auth.

    Anyway, I'll see if the Extended SQL does it better.

    Thanks.
    adriangodong
    0
  • Brian Donahue
    It may be that you had forgot to add the -I parameter if you are restoring a named instance.
    Brian Donahue
    0
  • adriangodong
    OK, problem resolved when using sqlcmd.

    Thanks!
    You could also use sqlcmd.exe to execute the stored procedure-formatted command and see if you get better results that way.
    adriangodong
    0

Add comment

Please sign in to leave a comment.