Microsoft
70-450 · Question #118
You administer a SQL Server 2008 instance that hosts a large database. The database has the following backup strategy: Full database backups are performed weekly. Differential backups are performed…
The correct answer is D. COPY_ONLY. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance that hosts a large database. The database has the following backup strategy:
Full database backups are performed weekly. Differential backups are performed daily. Transaction log backups are performed hourly. The recovery plan requires you to perform an unscheduled full backup. You need to perform a full database backup without interrupting the scheduled backup strategy. Which backup option should you use?
Options
- ASKIP
- BNOINIT
- CMIRROR TO
- DCOPY_ONLY
How the community answered
(38 responses)- A8% (3)
- B3% (1)
- C16% (6)
- D74% (28)
Community Discussion
No community discussion yet for this question.