You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales that has two data files and one transaction log file. Each data file is located on its own hard disk and exists in its own filegroup.You perform full database, differential, and transaction log backups on a regular basis. All backups made during a single week are striped across three disk backup devices. A portion of the header information for the current week's backups is shown in the following table.
BackupName BackupType BackupFinishDate
sales db 20000625 1 2000-06-25 21:57:04.000
sales tl 20000626_1 2 2000-06-26 11:04:22.000
sales tl 20000626_2 2 2000-06-26 15:06:33.000
sales df 20000626 5 2000-06-26 21:15:48.000
sales tl 20000627_1 2 2000-06-27 11:03:39.000
sales tl 20000627_2 2 2000-06-27 15:04:59.000
sales df 20000627 5 2000-06-27 21:31:13.000
sales tl 20000628_1 2 2000-06-28 11:05:16.000
On June 28, 2000, at 1:47 P.M., the hard disk that contains the PRIMARY filegroup fails. You want to recover as much data as possible.
What should you do? (Each correct answer presents part of the solution. Choose all that apply .)
A. Backup the transaction log by using the NO_LOG option.
B. Backup the transaction log by using the NO_TRUNCATE option.
c. Restore the most recent full database backup.
D. Restore the most recent differential backup.
E. Restore all differential backups in sequence.
F. Restore all transaction log backups in sequence.
G. Restore all transaction logs since the most recent differential backup.