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.
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center