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 Date and 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.

See Also

Other Resources

Restoring a Database to a Point Within a Backup

Help and Information

Getting SQL Server 2005 Assistance