Microsoft
70-432 · Question #135
You are mastering the company database, On a SQL Server 2008, you find out that one of the data files computer is broken. You should reserve the database which is from the most recent configurations…
The correct answer is A. You should run a transaction log backup for the database. See the full explanation below for the reasoning.
Question
You are mastering the company database, On a SQL Server 2008, you find out that one of the data files computer is broken. You should reserve the database which is from the most recent configurations of backups. In order to cut the lost, you should find the method as quickly as possible. Which is the correct answer?
Options
- AYou should run a transaction log backup for the database.
- BYou should reserve the old database backup for the database.
- CYou should reserve the most recent store produce log backup for the database.
- DYou should run the whole database backup.
How the community answered
(42 responses)- A79% (33)
- B12% (5)
- C7% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.