Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.5 - Configure Log Shipping 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.

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—Converts a LiteSpeed backup to a Double Click Restore executable, if the size of the backup is less than 4GB. If a backup is a native SQL Server backup or it is larger than 4 GB, it creates a Double Click Restore loader in the same location.
  • 2—Creates a Double Click Restore loader in the same location.

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).

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 Documents