When attempting to restore a database with more than 2100 paramaters (example Database with >2100 datafiles), restore fails with: There are too many parameters in this EXECUTE statement. The maximum number is 2100.
Steps to Reproduce:
1. use attached TSQL in giant_db_scriptsscript in SSMS to attempt a restore with the attached backup
2. note the returned error
3. used the attached Generate Database script to create a DB with 2K+ datafiles
4. backup the DB you crated with the generate script
5. try to restore the backup (if you restore over the existing, it will work, but if you modify all of the files to move them of course you will hit this issue)
Actual Results: LiteSpeed cannot restore a database if there are more than 2100 parameters in the script. Backup of DB with this many files succeeds because backup script doesn't need to enumerate all of the data/log files. Restore fails because there are so many move params.
STATUS: Fixed in a future version of LiteSpeed.
Extract backup to native in order to restore with SQL Server RESTORE DATABASE
Create database on destination server and simply restore (since MOVE parameters would not be required)
Also see Solution regarding attached files and folders of >2100 - CR60532