-
タイトル
Point in time restore left the database in a loading state. -
説明
Point in time restore using Enterprise Console left the database in a loading state when restoring a series of transaction logs. -
原因
The last command, indicating point in time restore of the last transaction log backup wasn't executed.
-
対策
WORKAROUND:
Restore the last transaction log backup manually in SQL Server Query Analyzer, to point in time, bringing the database back to the operating mode.
Example script:
exec master.dbo.xp_restore_log @database = 'Northwind', @filename = 'D:\Backup\Northwind200611170552LiteSpeed_Trans.BKP', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10'
exec master.dbo.xp_restore_log @database = 'Northwind', @filename = 'D:\Backup\Northwind200611170555LiteSpeed_Trans.BKP', @filenumber = 1, @with = 'RECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10', @with = 'STOPAT = N''2006-11-17 05:54:10'''
STATUS:
Issue fixed in version 4.7.0.00096. The latest version of LiteSpeed for SQL Server can be downloaded at: http://support.quest.com/support_download/Downloads.asp