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
@FileName='<path>'
[, @doubleclick = 1 | 2 ]
Specifies the path to the backup.
Creates a Double Click Restore executable. This argument accepts one of the following values:
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
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center