70-282 · Question #254
You work as the network administrator at Cer-tech.com. The Cer-tech.com network consists of a single Active Directory domain named Cer-tech.com. You install Microsoft Windows Small Business Server…
The correct answer is A. Back up the current active transaction log. See the full explanation below for the reasoning.
Question
You work as the network administrator at Cer-tech.com. The Cer-tech.com network consists of a single Active Directory domain named Cer-tech.com. You install Microsoft Windows Small Business Server 2003 with Microsoft SQL Server on a network computer. You have received instruction from the Manager to configure and install the data files by using SQL Server. Staff of the finance department makes use of these files to provide all bookkeeping reports to its clients. The data file is maintained on one disk and the transaction log file on a separate disk. The disk with the data file fails. You now need to recover the data completely. What should you do first?
Options
- ABack up the current active transaction log.
- BEvery transaction log needs to be restored in series.
- CFirst replace the failed disk.
- DThe full database backup should first be restored.
How the community answered
(71 responses)- A80% (57)
- B6% (4)
- C3% (2)
- D11% (8)
Community Discussion
No community discussion yet for this question.