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.
- Launch the Restore wizard.
- Select databases you want to restore.
- Specify a restore point.
- Review the restore summary.
Note |
Point-in-time restore is available only if transaction log backups exist. For more information, see Required Job Settings. |