White Papers

BP1014 Enhancing SQL Server Protection using Dell EqualLogic Snapshot Smart Copies
20
Recovery Task
Time to complete (seconds)
Restore full database (130 GB) to T0
900
Replay of 13 transaction Logs
1560
Recover database
29
Total
2489 (41:29)
3.5.2 Test 2 results: In-place restore from Smart Copy plus log replay
The total time required to complete database restore, recovery and place it back on-line was 5.5
minutes. The time required to complete each component of the process is shown in Table 3.
Table 3 – Database recovery using Smart Copy in-place restore plus log replay
Recovery Task
Time to complete (seconds)
Smart Copy restore
168
Replay of 1 transaction Log
135
Recover database
25
Total
328 (5:28)
3.5.3 Analysis and conclusion
In the case of database corruption, data loss events or other recovery scenarios that require restoring
from a known good state, the results of this test clearly show the potential for achieving significantly
faster system recovery times when using EqualLogic ASM/ME Smart Copy snapshots vs. using just the
SQL Server® native backup utility.