GUI Restore Wizard displays the full, differential and transaction log backup files. Restore scripts are generated without MOVE parameter for the differential and transaction log files.
Errors may include:
"SQL Server has returned a failure message to LiteSpeed 2005 which has prevented the operation from succeeding."
The following message is not a LiteSpeed 2005 message. Please refer to SQL Server books online or Microsoft technical support for a solution:
"RESTORE DATABASE is terminating abnormally.
File 'Northwind' cannot be restored to 'NewerNorthwind.mdf'. Use WITH MOVE to identify a valid location for the file.
Device activation error. The physical file name 'NewerNorthwind.mdf' may be incorrect."
Then:
"LiteSpeed 2005 Version 4.5.x
Copyright (C) 2004-2006, Imceda Software Inc. All Rights Reserved.
Registered Name: Quest
SQL Server has returned a failure message to LiteSpeed 2005 which has prevented the operation from succeeding."
The following message is not a LiteSpeed 2005 message. Please refer to SQL Server books online or Microsoft technical support for a solution:
"RESTORE LOG is terminating abnormally.
The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step."
Software bug
WORKAROUND:
T-SQL script may be manually altered and run via Query Analyzer in SQL Server.
Example:
exec master.dbo.xp_restore_database @database = 'NewerNorthwind', @filename = 'D:\Backup\Northwind200607111203LiteSpeed_Full.BKP', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10', @with = 'MOVE N''Northwind'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\NewerNorthwind_Data.mdf''', @with = 'MOVE N''Northwind_log'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\NewerNorthwind_Log.ldf'''
exec master.dbo.xp_restore_database @database = 'NewerNorthwind', @filename = 'D:\Backup\Northwind200607111204LiteSpeed_Diff.BKP', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10', @with = 'MOVE N''Northwind'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\NewerNorthwind_Data.mdf''', @with = 'MOVE N''Northwind_log'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\NewerNorthwind_Log.ldf'''
exec master.dbo.xp_restore_log @database = 'NewerNorthwind', @filename = 'D:\Backup\Northwind200607111204LiteSpeed_Trans.BKP', @filenumber = 1, @with = 'RECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10', @with = 'MOVE N''Northwind'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\NewerNorthwind_Data.mdf''', @with = 'MOVE N''Northwind_log'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\NewerNorthwind_Log.ldf'''
RESOLUTION:
This issue was fixed in LiteSpeed 4.6 The latest version of LiteSpeed for SQL Server may be downloaded at: http://support.quest.com/support_download/Downloads.asp.
