Perform a point-in-time database restore

Practice the sequence you already learned for “Perform a point-in-time database restore” until the order feels automatic. Drill the restore runbook from DBA training. The live database is not overwritten until the recovery point is verified in staging.

1. Confirm the required recovery-point time and ticket.
2. Identify the full backup and subsequent log backups that cover that time.
3. Restore the full backup to a staging instance with NORECOVERY.
4. Apply log backups up to the point in time.
5. Recover the staging database and verify the target rows or objects.
6. Cut over or copy only the verified objects to production.
7. Record the restore in the change record.