Which three files should you restore in sequence?

DRAG DROP

You have a database.

The existing backups for the database and their corresponding files are listed in the following table.

You purchase a new server. You must restore the database to the new server.

You need to restore the data to the most recent time possible.

Which three files should you restore in sequence? To answer, move the appropriate files from the list of files to the answer area and arrange them in the correct order.

Select and Place:

View Answer

Answer:

Explanation:

Step 1: Full.

Start with the full backup.

Step 2: Diff_20160503_1700.bak

Followed by the most recent differential backup.

Step 3: Log_20160503_1900.bak

And finally the most recent log backup (the only log backup done after the most recent differential backup).

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/differential-backups-sqlserver