Microsoft
70-450 · Question #105
You administer a SQL Server 2008 Enterprise Edition instance that hosts a large database. The database uses the simple-recovery model. The database contains the following three additional…
The correct answer is A. Perform a full database restore. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 Enterprise Edition instance that hosts a large database. The database uses the simple-recovery model. The database contains the following three additional filegroups:
- FileGroupA that is read/write
- FileGroupB that is read-only
- FileGroupC that is read-only
FilegroupB contains less critical data than FilegroupC. You discover that the PRIMARY filegroup and FileGroupB have failed. You need to recover the database in the minimum possible time. You also need to ensure that data is available as soon as possible. What should you do?
Options
- APerform a full database restore.
- BPerform a partial restore of the PRIMARY filegroup and FileGroupB from a partial backup.
- CPerform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup.
- DPerform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup.
How the community answered
(21 responses)- A81% (17)
- B10% (2)
- C5% (1)
- D5% (1)
Community Discussion
No community discussion yet for this question.