-
Title
SQL Server stored procedures can only accept 2100 parameters attached files & folders -
Description
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) -
Cause
Software Defect
-
Resolution
STATUS: Fixed in a future version of LiteSpeed.
WORKAROUND:When instructing the xp_restore_database to restore just the folder, the files are included. Alter the t-sql script that the GUI creates, and rename the folder (if it exists on the destination server), so that it could be created during the restore.exec master.dbo.xp_restore_database @database = N'Grand_Canyon' ,@filename = N'D:\Backup\2005\Grand_Canyon_200903131056.bak',@filenumber = 1,@with = N'STATS = 10',@affinity = 0,@with = 'REPLACE',@logging = 0,@attachedfile = 'D:\Backup\2005\Northwind\ to D:\Backup\2005\Northwind\'--@attachedfile = 'D:\Backup\2005\Northwind\Northwind_db_200803190643.BAK to D:\Backup\2005\Northwind\Northwind_db_200803190643.BAK',--@attachedfile = 'D:\Backup\2005\Northwind\Northwind_db_200803190645.BAK to D:\Backup\2005\Northwind\Northwind_db_200803190645.BAK' -
Defect ID
ST60469 -
Attachments
-
Additional Information
Also see SOL52479 for CR60532 regarding >2100 datafiles
