70-450 · Question #102
You administer a SQL Server 2008 database solution. All data modifications are performed through stored procedures that use only the INSERT, UPDATE, or DELETE statements. You are designing a backup…
The correct answer is D. Use the full-recovery model along with transaction log backups. Full-recovery Model - Requires log backups. - No work is lost due to a lost or damaged data file. - Can recover to an arbitrary point in time (for example, prior to application or user error). Work loss exposure - Normally none. - Il the tail of the log is damaged, changes…
Question
You administer a SQL Server 2008 database solution. All data modifications are performed through stored procedures that use only the INSERT, UPDATE, or DELETE statements. You are designing a backup strategy. You need to ensure that the following business requirements are met:
- The backup strategy supports point-in-time recovery for failure at
any time of day.
- The transaction log uses the least amount of disk space.
What should you do?
Options
- AUse hourly database snapshots.
- BUse the full-recovery model along with differential backups.
- CUse the simple-recovery model along with differential backups.
- DUse the full-recovery model along with transaction log backups.
How the community answered
(21 responses)- A5% (1)
- B14% (3)
- C5% (1)
- D76% (16)
Explanation
Full-recovery Model - Requires log backups. - No work is lost due to a lost or damaged data file. - Can recover to an arbitrary point in time (for example, prior to application or user error). Work loss exposure - Normally none. - Il the tail of the log is damaged, changes since the most recent log backup must be redone. Recover to point in time S3. - Can recover to a specific point in time, assuming that your backups are complete up to that
Topics
Community Discussion
No community discussion yet for this question.