Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Point in Time Restore

Use the Point in Time Restore dialog box to set the point in time at which to stop the restore operation.

To use SQL Server Management Studio to restore a database to a point in time

Most recent point in time possible

Restores the database to the point in time of the most recent backup among the backup sets selected for the restore operation.

A specific date and time

Restores the database to the date and time specified in the Dateand the at (time) settings. The order and delimiters among the date fields and time fields depend on the regional settings of the computer.

Date

Specify the date to which to restore the database. The date setting contains month, day, and year fields. Type directly in these fields, or click the arrow to open a calendar application, where you can select a date.

Time

Specify the exact time to which to restore the database. The time setting contains hour, minute, and second fields. If your system uses a 12-hour clock, a fourth field indicates whether the time is in morning (A.M.) or afternoon/evening (P.M.). Type directly in each of these fields, or click the up or down arrows to change the value of the adjacent fields.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.