Database restore with attached files scripts each file, even if files are in subfolders, which hits the 2100 parameter limit and fails
Steps to Reproduce:
1. install 5.0.2
2. backup a database and include several single files as well as a folder with several files inside it as attached files (note the TSQL script parameters)
3. after the backup is complete, restore the file into a new database using the restore wizard
4. browse through the wizard and note the restore script - the attached files that were in the folder should each be scripted separately
5. restore should fail with There are too many parameters in this EXECUTE statement. The maximum number is 2100.
**see my script examples below**
if a user is restoring a backup with many attached files (user in associated case had 6835), because each is scripted separately, the number of parameters exceeds the 2100 limit (see also CR60469)
Software Defect
STATUS: Fixed in a future version of LiteSpeed.
WORKAROUND:
Also see SOL52479 for CR60532 regarding >2100 datafiles
