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 Naming Conventions
Double Click Restore conversion may modify the extension of the backup file.
For LiteSpeed backups, file name conversion depends on whether you create a double click restore loader. By default you will create a double click restore loader. 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. If you do not create a double click restore loader then the backup file name will have the .exe extension.
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 |
|---|---|---|
|
Create one Double-Click Restore executable file. The executable may be greater than 4GB for large databases. Windows Server is unable to run executable files larger than 4GB. However, the file will be convertible/restorable by LiteSpeed file. @doubleclick = 1 |
X.exe |
X.exe (No name changes) |
| X | X.exe | |
|
Create a Double Click Restore Loader (Default). @doubleclick = 2 |
X.exe |
X* |
| X |
X* (No name changes) | |
| Native SQL Server | X.exe |
X* |
| X |
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. | ||
Create Double Click Restore Executables
To create a new Double Click Restore executable, do one of the following:
- Select the Create a Double Click Restore executable... option when creating backups in the LiteSpeed UI Console.
- Supply @doubleclick = 2 when creating a backup using procedures. For more information, see xp_backup_database.
- Supply --doubleclick 2 when creating a backup using command-line interface. For more information, see LiteSpeed Command-Line Arguments.
|
Scenario You need to restore particular compressed and encrypted LiteSpeed backups on a server that does not have LiteSpeed
|
Click hereTo restore LiteSpeed backups on a server that does not have LiteSpeed
- Define which backup files are needed for the restore and convert them to the Double Click Restore executables. Do one of the following:
- Right-click a backup in the Backup Browser tab or in the Backup History tab and select Convert to Double Click Restore backup.
-
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.