The following backups have been created for an SQL Server database in the corresponding chronological order (D<N> stands for a full database backup, L<N> for a transaction log backup, and +<N> for a differential backup):

D1 L1 L2 +1 L3 L4 +2 L5 L6 D2 L7 L8 +3 L9. After a disk crash, which results in the loss of at least one data file of this database, the database administrator backs up the current transaction log to create the backup L10. Which are the possible sequences for applying some of the backups to restore the database without any loss of data? (Choose two)

Question

The following backups have been created for an SQL Server database in the corresponding chronological order (D<N> stands for a full database backup, L<N> for a transaction log backup, and +<N> for a differential backup):

D1 L1 L2 +1 L3 L4 +2 L5 L6 D2 L7 L8 +3 L9. After a disk crash, which results in the loss of at least one data file of this database, the database administrator backs up the current transaction log to create the backup L10. Which are the possible sequences for applying some of the backups to restore the database without any loss of data? (Choose two)

Accepted Answer

A. D2 L7 L8 L9 L10 B. D1 +1 L3 L4 L5 L6 L7 L8 L9 L10

Answer

C. D2 +3 L9

Answer

D. D1 +2 L5 L6 +3 L9 L10

Answer

E. D1 +1 L3 L4 +2 L5 L6 L7 L8 L9 L10

The following backups have been created for an SQL Server database in the corresponding chronological order (D<N> stands for a full database backup, L<N> for a transaction log backup, and +<N> for a…

Question

Options

How the community answered

Community Discussion