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.
4. Review the restore summary.