Which five actions should you perform in sequence?

DRAG DROP

You manage a database named DB1 that uses the following filegroups:

The database is configured to use full recovery model. Transaction logs are backed up to a backup set named TLogBackup.

The PRIMARY and FG2 for DB1 are damaged. FG1 and FG3 are intact.

You need to design a piecemeal restore plan that meets all the above requirements. You need to bring critical filegroups online as soon as possible while minimizing restoration time. All damaged filegroups must be online after the restore operation completes.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

Step 1: Perform a differential database backup…

Step 2: Perform a tail-log backup…

A tail-log backup captures any log records that have not yet been backed up (the tail of the log) to prevent work loss and to keep the log chain intact. Before you can recover a SQL Server database to its latest point in time, you must back up the tail of its transaction log. The tail-log backup will be the last backup of interest in the recovery plan for the database.

Step 3: The PRIMARY and FG2 for DB1 are damaged. FG1 and FG3 are intact.

Step 4: Transaction logs are backed up to a backup set named TLogBackup.

Step 5: The PRIMARY and FG2 for DB1 are damaged.

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-files-and­filegroups-sql-server?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server? view=sql-server-2017