VDI error 1010 when trying to perform backup

Neil DavidsonNeil Davidson Posts: 281
edited April 5, 2005 12:55PM in SQL Backup Previous Versions
Stephane,

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

osql

And let me know what happens
- Neil Davidson
Red Gate Software Ltd

Comments

  • 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 DonahueBrian Donahue Posts: 6,590 New member
    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.
  • actually a reboot and a change of logins seemed to help this problem. Thanks
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Good! Thanks for getting back to us.
Sign In or Register to comment.