Sql-server – Which Log should I start backups with

backuprestoresql server

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.

Best Answer

You need to restore last FULL backup, the Differential, the 10:15 transaction backup and the 10:30 one with the STOPAT = '2015-05-22 22:24:00' clause.