Restoring Point-in-Time State
You can restore a Microsoft SQL Server database as of a point-in-time state in your restore point.
The data will be restored in the following manner:
- Database files will be mounted to the original Microsoft SQL Server machine and copied to the original location.
- If a database with the same name already exists on a target Microsoft SQL Server machine, you will be prompted to overwrite the database with that from the backup file.
To restore SQL Server databases as of a point-in-time state, use the Restore wizard.
- Launch the Restore wizard.
- Specify a restore point.
- Fine-tune the 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. |