Point in time restore must be for one second prior to time desired, i.e., to recover to 15:00, time entered would be 14:59:59
WORKAROUND:
Set Point in Time restore must be for one second prior to time desired, i.e., to recover to 15:00:00, time entered would be 14:59:59 However the Restore Wizard does not display seconds, so user must enter a value of one minute less than the point to be restored.
The correct syntax may be run via t-sql script in Query Analyzer:
exec master.dbo.xp_restore_database @database = 'Northwind', @filename = 'D:\Backup\Northwind200609121337LiteSpeed_Full.BKP', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10'
exec master.dbo.xp_restore_log @database = 'Northwind', @filename = 'D:\Backup\Northwind200609121737LiteSpeed_Trans.BKP', @filenumber = 1, @with = 'RECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10',
@with = 'STOPAT = N''2006-09-12 13:59:59'''
STATUS:
An enhancement request has been submitted to Development for consideration in future release for LiteSpeed for SQL Server
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy