Options
VDI Error
adriangodong
Posts: 11
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.
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.
Comments
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.
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.
You could also use sqlcmd.exe to execute the stored procedure-formatted command and see if you get better results that way.
Anyway, I'll see if the Extended SQL does it better.
Thanks.
Thanks!