Microsoft
70-282 · Question #144
You are the network administrator for Company which is an accounting company.You install Windows Small Business Server 2003 with SQL Server on a network computer. You use SQL Server to configure and…
The correct answer is C. Back up the current active transaction log. See the full explanation below for the reasoning.
Question
You are the network administrator for Company which is an accounting company.You install Windows Small Business Server 2003 with SQL Server on a network computer. You use SQL Server to configure and install the data files. You store the data file on one disk and the transaction log file on another. The disk with the data file fails. What should you do first to recover the data completely?
Options
- AUse a new disk to replace the failed one.
- BImplement RAID-5 solution.
- CBack up the current active transaction log.
- DRestore each required transaction log in sequence.
How the community answered
(28 responses)- A4% (1)
- B14% (4)
- C75% (21)
- D7% (2)
Community Discussion
No community discussion yet for this question.