How to extract attached files which are included with a LiteSpeed databse backup?
Example: mybackup.sls comprising a single database backup file and a folder eg. d:\myfolder
The GUI options do not include an option to extract the attached files/folders.
Run the xp_restore_attachedfilesonly first, then extract the backup of the database as a second step.
exec master.dbo.xp_restore_attachedfilesonly
@filename = N'D:\Backup\2005\AdventureWorksDW_201111180556_attach.bak',
@filenumber = 1,
@attachedfile = N'''D:\Customer Data\test.jpg'' to ''D:\Customer Data\test.jpg'''
then from command line
>extractor.exe -Fd:\Backup\2005\AdventureWorksDW_201111180556_attach.bak -Ed:\Backup\2005\AdventureWorksDW_201111180556_attachNATIVE.bak -N1
