HP
HP0-J53 · Question #24
Your customer wants to back up their P4000-based 1.5TB Microsoft SQL 2008 R2 database nightly, but minimize the backup window. You have recommended using snapshots of the LUNs to create backups…
The correct answer is C. Use the Microsoft Volume Shadow Copy Service (VSS) to keep the SQL I/Os consistent. See the full explanation below for the reasoning.
Question
Your customer wants to back up their P4000-based 1.5TB Microsoft SQL 2008 R2 database nightly, but minimize the backup window. You have recommended using snapshots of the LUNs to create backups. What else must you do to keep the data consistent without stopping the application?
Options
- AUse the Thin Provisioning features of the P4000 to create a mirror and back up from the mirror.
- BUse the Microsoft SQL Server Backup Service to keep the SQL I/Os consistent.
- CUse the Microsoft Volume Shadow Copy Service (VSS) to keep the SQL I/Os consistent.
- DUse the Centralized Management Console (CMC) to pause I/O and then take a snapshot.
How the community answered
(43 responses)- A2% (1)
- B16% (7)
- C74% (32)
- D7% (3)
Community Discussion
No community discussion yet for this question.