This topic has not yet been rated - Rate this topic

Point in Time Restore

SQL Server 2008 R2

Other Versions

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? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions