White Papers

BP1014 Enhancing SQL Server Protection using Dell EqualLogic Snapshot Smart Copies

 Test 2

o We performed a system recovery to the same point in time as in test #1.

o In this test case we restored using the most recent Auto-Snapshot Manager snapshot

Smart Copy (using Auto-Snapshot Manager in-place restore with the apply logs

option).

o After completing the in-place restore we replayed necessary incremental or

transaction log backups from that point forward using the SQL Server® native backup

utility.

Figure 11 below illustrates the recovery timeline components involved in each test. Note in Figure 11

the difference in recovery set components that are needed to complete database recovery

(highlighted for each method).

Figure 11 – Recovery point timeline comparison

3.5.1 Test 1 results: database recovery from SQL Server full backup plus log replay

The total time required to complete database restore, recovery and place it back on-line was 41.5

minutes. The time required to complete each component of the process is shown in Table 2.

Table 2 – Database recovery from SQL Server full backup plus log replay