How can we help you today? How can we help you today?

SQLBkup 3 - VDI Error 1010 input query is too long

  • Date: 24 March 2005
  • Versions affected: 3.0.0

When performing a restore of a database, either using the SQLBACKUPC.exe command or the GUI, your restore operation may fail with the following error message:
VDI Error 1010: SQL Message: input query is too long

This can happen if the command string shown in the Stored Procedure view of the restore command is longer than 1002 characters. This will be addressed in a future release.

As a workaround for the problem, consider using shorter paths in the MOVETO parameters or use wildcards rather than explicitly listing filenames.
Brian Donahue
0

Comments

1 comment

  • Brian Donahue
    This problem has been fixed in SQL Backup 3.2 by saving the SQL to a temporary file, then calling OSQL.exe to load this file and run the SQL commands inside.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.