If Create a double-click restore is clicked first, then the files #1, #2, #3 are added, the 1-2-1 files are created. If the user adds the files #1, #2, #3 first, and THEN clicks the Create a double-click restore button, 1-2-3 files are created.
WORKAROUND:
Create the original Double-Click backup file using the LiteSpeed "On the Destination (Disk)" window of the Backup Wizard. Select the check box labeled: "Create double-click restore (extension will be changed to .exe)". This feature is only available for disk destinations.
Note: MS Windows Operating System limit: no executable can be over 4 gigabytes, even on 64-bit MS Windows. Since striping of backups is allowed with double-click Restore, it is possible to create double-click Restore sets for database backups greater than 4 gigabytes; it is the user's responsibility to estimate how many stripes are needed for this.
Add the files #1, #2, #3 first, THEN click the Create a double-click restore button. The first file will be labeled with the 'exe' extension, all other striped files will be labeled with 'bkp' extensions.
The script for this process would resemble:
exec master.dbo.xp_backup_database @database = N'Northwind', @GUID = ###', @filename = N'D:\Backup\Northwind1.exe', @filename = N'D:\Backup\Northwind2', @filename = N'D:\Backup\Northwind3', @backupname = N'Northwind backup', @desc = N'Backup of Northwind on 2007-01-15 06:54:52', @logging = 0, @doubleclick = 1, @with = N'SKIP', @with = N'STATS = 10'
Restore: exec master.dbo.xp_restore_database @database = N'Northwind', @filename = N'D:\Backup\Northwind1.exe', @filename = N'D:\Backup\Northwind2', @filename = N'D:\Backup\Northwind3', @filenumber = 1, @with = N'RECOVERY', @with = N'NOUNLOAD', @with = N'STATS = 10'
Note: A backup created on Itanium or x64 cannot be restored on a different OS type.
STATUS:
Issue fixed in version 4.6x. The latest version of LiteSpeed for SQL Server can be downloaded at: http://support.quest.com/support_download/Downloads.asp
