Restore of backups are failing after upgrading to Litespeed 6.5 when using scripts to do the rest (4319993)

Restore of any database backups using a script such as the example below is failing:

exec master.dbo.xp_restore_database

@database = N'ROBBIE'

, @filename= N'C:\Backup\Robbie.BAK'

, @encryptionkey = N'encryption-key'

, @filenumber = 1

, @Buffercount = 30

, @logging = 2

, @trace = 'logpath = C:\Temp\LitespeedLog'

, @with = N'NOUNLOAD'

, @with = N'STATS = 1'

, @with = N'REPLACE'

, @with = N'RECOVERY'

, @with = N'MOVE "ROBBIE" TO "W:\MSSQL\Robbie2.mdf"'

, @with = N'MOVE "Robbie_log" TO "W:\MSSQLLogs\Robbie_log.ldf"'

GO

The problem being seen is a SQL Server problem, not a Litespeed issue where double quotes wrapping are used which is not supported by native SQL Server. In past versions of LItespeed for SQL Server we have changed the double quotes to be single quotes to enable restores to work.

A future update to the release notes will include the above mentioned problem as the issue was found after Litespeed for SQL Server 6.5 went GA.

Please accept our apologies for this issue and for the fact that any scripts will need to be re - written with the double quotes changed to single quotes to make the restore script work.