LiteSpeed for SQL Server 8.9.8 - Security and Compliance Guide

xp_slsCreateDCR

This stored procedure converts a Native or LiteSpeed backup file to a Double Click Restore backup, a self-executing and self-extracting backup that can be restored on a server instance that does not have LiteSpeed installed. It also performs a rename on the file if applicable. Double Click Restore Executables

NOTE: A Double Click Restore can only be created for a disk file.

This stored procedure converts a backup to an executable by running SLSDCR utility against <path> and supplying the correct LiteSpeed component (SLSRestore.exe and SqlLiteSpeedx32.exe) executable paths. The packager inserts itself into the header of a LiteSpeed backup file. Other two utilities are required for executing a double-click restore and are also attached. Double click are executables are now created from backup files. Backup files are no longer appended to the GUI.

Syntax

exec xp_slsCreateDCR
@FileName='<path>'
[, @doubleclick = 1 | 2 ]

Agruments

@filename

Specifies the path to the backup.

@doubleclick

Creates a Double Click Restore executable. This argument accepts one of the following values:

• 1—Creates one Double-Click Restore executable file. Note the following warning: 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.
• 2—Creates a Double Click Restore loader in the same location. (Default)

For more information, see Double Click Restore Executables.

Example

exec xp_slscreatedcr
@FileName = N'I:\test\test.bak'

Returns

0 (success) or non-zero (failure). Message indicating success or failure of the operation.

To capture the output message, run the following:

declare @rmsg varchar(999)
exec master..<procedure_name> <arguments>, @resultmsg=@rmsg output
select @rmsg

To capture the output message and the result code, run the following:

declare @rc int
declare @rmsg varchar(999)
exec master..<procedure_name> <arguments>, @resultmsg=@rmsg output, @resultcode=@rc output
select @rc, @rmsg

Related Topics

About Using Extended Stored Procedures

Double Click Restore Executables