What are the challenges you face when working across database platforms? Take the survey

VDI error 1010 when trying to perform backup

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

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


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


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