VDI error 1010 when trying to perform backup

Neil Davidson

Stephane,

Can you open a command-line prompt and type run the following command:

osql

And let me know what happens

jayrod

I'm getting the same thing. However when I open up osql i'm able to connect with a username and password as well as run a query on the master db.

What else can I try?

Brian Donahue

Hello Jayrod,

The VDI error 1010 error can also happen if the command SQL Backup is trying to run exceeds 1002 characters in length. This is a limitation in OSQL.exe.

If you look at the SQL Backup command that you're running using the 'stored procedure' view, you can try economizing on the length of this command by using mapped drives in place of UNC paths if they are very long and use wildcards wherever possible.

We will be working on removing the dependence on OSQL.exe in a future version.

jayrod

actually a reboot and a change of logins seemed to help this problem. Thanks

Brian Donahue

Good! Thanks for getting back to us.