Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.5 - Installation Guide


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.


exec xp_slsCreateDCR
[, @doubleclick = 1 | 2 ]



Specifies the path to the backup.


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.


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


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 Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating