Options

SQLBkup 3 - VDI Error 1010 input query is too long

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited July 18, 2005 10:06AM in Knowledge Base
  • 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.

Comments

Sign In or Register to comment.