Double-Click Restore cannot restore attached files and directories using Graphical User Interface (GUI).
WORKAROUND1:
Attached files may be restored with double-click exe file using script via Query Analyzer.
xp_restore_headeronly @filename=<<filename>>, @attachedfiles=1 will display the list of all attached files in the backup file (or use @filenumber=<<backup number>> for a specific backup within the file). @attachedfiles=2 will display both the headers and the attached files.
The attached files may also be restored without the database by substituting xp_restore_database with xp_restore_attachedfilesonly. The script would be similar to:
exec master.dbo.xp_restore_attachedfilesonly @filename = 'D:\Backup\Northwind200612091259LiteSpeed_Full.exe', @encryptionkey = 'password', @filenumber = 1, @attachedfile='C:\Program Files\Microsoft Office\CLIPART\Publisher\Backgrounds\J0143743.GIF', @attachedfile='C:\Documents and Settings\user\My Documents\My Pictures\021.jpg'
Note: During the restore of a double-click striped file, the executable, and all the additional .bak files produced by the backup (stripes), must be present together in the same directory to complete the restore.
A double-click restore only works on a computer that has MS SQL Server installed on it, with the version of MS SQL Server matching the version used to create the double-click restore. A backup created on Itanium or x64 cannot be restored on a different OS type.
See the LiteSpeed Help File for additional information on running Double-Click Restore from the command line.
WORKAROUND2:
Double-click restore can be initiated through the command line and include the attached files...and they will be restored.
Sample script which restored two files and a folder which contained two files:
STATUS:
Waiting for fix in a future release of LiteSpeed.
All versions of SQL Server
