LiteSpeed executables can be created for Native SQL Server and LiteSpeed disk backups. In many cases, LiteSpeed disk backups can be directly converted to Double Click Restore executables.
A Double Click Restore is an executable that has an .exe extension and performs a database restore when double-clicked. An executable file allows you to restore a backup on a server instance that does not have LiteSpeed installed.
A Double Click Restore executable is created by either writing a loader program designed to restore backup files, or by inserting the loader directly into the header of a suitable LiteSpeed backup file. If you convert a striped backup file, the first file will be the executable (.exe), and the others will remain unchanged.
Double Click Restore conversion may modify the extension of the backup file.
For LiteSpeed backups, file name conversion depends on the backup file size. If the backup file size is less than 4 GB, then the backup file name will have the .exe extension. If the backup file is larger than 4 GB, then the backup file name will not have the .exe extension and LiteSpeed will create X.exe, the empty Double Click Restore loader that restores the backup when double-clicked.
For native SQL Server backups, LiteSpeed will create the empty Double Click Restore loader that has the .exe extension and restores the backup when double-clicked.
|Backup Type||Name Before Conversion||Name After Conversion|
X.exe (No name changes)
X* (No name changes)
|Native SQL Server||X.exe||
X* (No name changes)
*—X.exe is created as empty Double Click Restore loader. You can locate it in the same directory as the converted X.
To create a new Double Click Restore executable, do one of the following:
Click here to see the procedure for this scenario.
To restore LiteSpeed backups on a server that does not have LiteSpeed
Run exec xp_slsCreateDCR @FileName='<path>'
where <path> is the path to the backup.
Copy the Double Click Restore executable(s) you created to the server that does not have LiteSpeed.
NOTE: If a backup file is more than 4 GB, you need to copy both the converted backup file and the empty Double Click Restore loader.
Log on to the server, double-click the first Double Click Restore Executable file to restore and complete the LiteSpeed Double Click Restore dialog. Repeat for all other files.
NOTE: If you deselected and selected appended backups to restore, you may need to re-enter the encryption password.