SQL Server Restore Practice: Which Backups Do You Restore?

Unlimited SQL Server restore practice. Each problem shows a backup history and a target time: tap the backups to restore, in order, using as few as possible. A wrong answer names the slip, such as restoring every differential.

Sales database backups · full recovery model

Tapped: 0

Answer to see the working.

SQL Server exam prep

Preparing for DP-300? Start with the free real exam questions, then get the full pack.

Microsoft DP-300373 real exam questions · US$39
Free: 93 questionsGet the full pack

Restore FAQ

What order do you restore full, differential and log backups in?

One full backup first, then the most recent differential based on it, if there is one, then every log backup made after the last one you restored, in order. Each is restored WITH NORECOVERY, and the database is recovered at the end.

Can a copy-only full backup be the base of a differential?

No. A copy-only full backup can't serve as a differential base and doesn't change it, so a later differential is still based on the most recent regular full backup. A copy-only full can still start a restore, followed by the logs after it.

Do you restore every differential backup?

No. Restore its base, then only the most recent differential. Each differential holds every change since its full backup.

Does a full backup break the log chain?

No. The log chain is independent of data backups. In Microsoft's example the 8:00 PM log backup holds the log from 4:00 PM to 8:00 PM, across the 6:00 PM full backup, so the 8:00 AM full and all the logs after it still restore.

Which log backup holds a point in time?

The first log backup made after that time. A point in time is always restored from a log backup, with the same STOPAT time on every RESTORE LOG statement.

What happens if a log backup is lost?

The chain breaks there: from an earlier backup you can restore only the logs before the missing one. In this drill the way past it is a full or differential backup made after the lost log.

When do you need a tail-log backup?

To restore to the point of failure. The tail-log backup captures the log not yet backed up and is the last backup in the restore. You don't need one if the target is inside an earlier log backup.

Is this on the DP-300 exam?

Yes. The DP-300 study guide lists "Perform a database restore by using native tools" and "Perform a database restore to a point in time" under Plan and perform backup and restore of a database.

What does this drill leave out?

The simple and bulk-logged recovery models, copy-only log backups, file, page and online restores, and Azure SQL automated backups. Every problem is one database in the full recovery model, with invented times.

Sources
  • Microsoft Learn, Complete database restores (full recovery model): the restore sequence (most recent full, most recent differential, then the logs from the first one after the backup just restored) and the two worked examples (Wednesday 5:19 A.M., and Thursday 3:04 A.M. with the 3:00 A.M. differential unavailable). The drill's tests reproduce both.
  • Differential backups: a differential is based on the most recent previous full backup, copy-only fulls excepted; restore its base first, then only the most recent differential.
  • Copy-only backups: a copy-only full backup can't serve as a differential base, and restoring one is the same as restoring any other full backup.
  • Transaction log backups and Apply transaction log backups: the log chain is independent of data backups; logs are restored in order after the full or differential; with a lost log only the logs before it can be restored; the 8:00 A.M. and 6:00 P.M. example, reproduced in the tests.
  • Restore a database to a point in time: a point in time is always restored from a log backup, from a full backup that ends before the target, up to and including the log that contains it, with STOPAT on every RESTORE LOG.
  • Tail-log backups, Full database backups and Restore and recovery overview: the tail-log backup is the last backup of interest; a backup represents the database when it finished; the recovery models.
  • Exam DP-300 study guide (skills measured as of October 27, 2026): "Perform a database restore by using native tools" and "Perform a database restore to a point in time".
  • Checked 21 November 2026. The tool's own approach: one database in the full recovery model, ten backups at invented times, each time being when that backup finished, at most one backup lost, and the right answer is the restore with the fewest backups (only problems with exactly one such restore are shown). An independent re-solver agreed with the drill on 20,000 generated problems.

Checked 21 November 2026 against Microsoft Learn: the SQL Server backup and restore articles.

More free tools

All free tools