Restoring Litespeed Backup in Single User Mode (4284984)

You may encounter problems when attempting to restore a Litespeed backup on a database in single user mode within SSMS.

Sample script shown below:

ALTER DATABASE Database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Exec Master.dbo.XP_RESTORE_BACKUP
@database = NDatabase_name,
@filename = NL:\backup\Database_name.bak,
@filenumber = 1,
@with = NREPLACE,
@with = NSTATS = 10,
@with = NMOVE NData_1 TO NC:\datafiles\data\data1.mdf,
@with = NMOVE NData_2 TO ND:\datafiles\data\data2.ndf,
@with = NMOVE Nlog TO NE:\datafiles\log\log1.ldf,
@affinity = 0,
@logging = 0
Alter database database_name SET MULTI_USER
GO

The above script will most certainly fail because XP_RESTORE_BACKUP will always try to open a second connection.

You do not want to use the command prompt nor kill cursor technique.