Restoring Point-in-Time State

When restoring multiple databases, consider that depending on the database recovery model the following cases are possible:

  • Some databases may be restored as of the different time interval.
  • Some databases cannot be restored if there are no transaction logs available for the specified period.

To restore Microsoft SQL Server databases as of the point-in-time state, use the Restore wizard.

  1. Launch the Restore wizard.
  2. Select databases you want to restore.
  3. Specify a restore point.