We have log backups running every 15 minutes and nightly fulls/diffs (fulls are once a week per DB, but they are spread across the whole week for load balancing). Lets say for a particular DB I have a diff that starts at 10:05pm and finishes at 10:18pm and I have log backups at 10:00pm, 10:15pm, and 10:30pm. If I want to restore to 10:24pm that night, I know I need to restore the last full and the diff from that night, but then I'm not sure which transaction log I should start with after that.
Sql-server – Which Log should I start backups with
backuprestoresql server
Related Question
- Sql-server – FULL recovery and differential backups
- Sql-server – Transaction Log Backups
- Sql-server – SQL recovery model for ADFS deployment
- Sql-server – (Ola Hallengren) Deleting transaction log backups
- Sql-server – How to create a test copy of the production database that is updated daily on SQL Server
- Sql-server – way to reduce the amount of time spent on a point in time recovery
- Sql-server – Do Log Backups depend on Differential Backups
Best Answer
You need to restore last
FULL
backup, theDifferential
, the 10:15transaction
backup and the 10:30 one with theSTOPAT = '2015-05-22 22:24:00'
clause.