Exam4Training

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:

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

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version