Options

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
· Share on Twitter

Comments

  • Options
    jayrodjayrod Posts: 2
    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?
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • Options
    jayrodjayrod Posts: 2
    actually a reboot and a change of logins seemed to help this problem. Thanks
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Good! Thanks for getting back to us.
    · Share on Twitter
Sign In or Register to comment.