Return
-
Title
Enhancement Request - Double click restore files do not include the Point in Time parameter in th -
Description
Double click restore files do not include the Point in Time parameter in the DCR GUI. The Tlog backup files can be restored to a point in time via command line, script or by extracting to native format.
-
Resolution
WORKAROUND 1:
DCR file can be extracted to a native SQL Server format, then restore to Point in Time with native SQL syntax script.
WORKAROUND 2:
Point in Time restore from tlog exe file:
exec master.dbo.xp_restore_database @database = N'Northwind' ,
@filename = N'D:\Backup\2005\Native_Northwind_201104130652.bak',
@filenumber = 1,
@with = N'REPLACE',
@with = N'STATS = 10',
@with = N'NORECOVERY',
@affinity = 0,
@logging = 0exec master.dbo.xp_restore_log @database = N'Northwind' ,
@filename = N'D:\Backup\2005\Northwind_201104131032.exe',
@filenumber = 1,
@with = N'REPLACE',
@with = N'STATS = 10',
@with = N'RECOVERY',
@with = N'STOPAT = N''2011-04-13T10:31:44''',
@affinity = 0,
@logging = 0
GOSTATUS: In Development for consideration in future versions of LiteSpeed -
Defect ID
CR84164