What should you specify when you run the recovery command?

A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a backup strategy that creates backups for the filegroups.

DB1 experiences a failure. You must restore FG1 and then FG2.

You need to ensure that the database remains in the RECOVERING state until the restoration of FG2 completes. After the restoration of FG2 completes, the database must be online.

What should you specify when you run the recovery command?
A . the WITH NORECOVERY clause for FG1 and the WITH RECOVERY clause for FG2
B . the WITH RECOVERY clause for FG1 and the WITH RECOVERY clause for FG2
C . the WITH RECOVERY clause for both FG1 and FG2
D . the WITH NORECOVERY clause for both FG1 and FG2

View Answer

Answer: A