You are the database administrator of a SQL Server 2005 computer running SQL Server 2005 Enterprise Edition. You support a database named OnlineSales. This database exists on the following three filegroups. The primary filegroupFG1, a read/write filegroup FG2, a read/only filegroup with historical data. The database is set to the Full Recovery model.
You discover that a file from FG1 has been corrupted. FG1 is offline. All other filegroups are online. You need to restore FG1 while minimizing the time when no data is available.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Restore the transaction logs since the most recent full or filegroup backup.
B.
Restore the most recent full database backup.
C.
Restore the most recent backup of the FG1 filegroup.
D.
Restore the FG2 filegroup.
E.
Restore the most recent backup of the Primary filegroup.
Explanation:
For a database that uses the full or bulk-logged recovery model, after using RESTORE DATABASE to restore one or more files, filegroups, and/or pages, typically, you must apply the transaction log to the files containing the restored data;applying the log makes those files consistent with the rest of the database.