BUG: Point-in-Time Recovery Adds Incorrect Seconds Value to Recovery Time Selected in SEM (260235)


The information in this article applies to:

  • Microsoft SQL Server 7.0
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 "Backup set date" 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.

REFERENCES

Microsoft SQL Server Books Online, topic: "How to restore to a point in time (Transact-SQL)"
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbDSupport KB260235
©2002 Microsoft Corporation. All rights reserved.