Microsoft KB Archive/260235

= BUG: Point-in-Time Recovery Adds Incorrect Seconds Value to Recovery Time Selected in SEM =

Article ID: 260235

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q260235



BUG #: 57678 (SQLBUG_70)



SYMPTOMS
In the SQL Server Enterprise Manager, when you use the Restore Database dialog box to restore a database to point-in-time, after you select the Point in time restore check box to open the Point In Time Restore dialog box, you can only specify the time up to the minute in the Time text box. However, afterwards some seconds are added in the Point in time restore text box. The value of seconds that are added is equal to the value in the &quot;Backup set date&quot; for the last selected transaction log backup. Furthermore, the restore process does restore to that second.



WORKAROUND
To restore the database to a point in time with precision up to seconds, use a RESTORE DATABASE statement followed by a RESTORE LOG TSQL statement in the SQL Server Query Analyzer.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.