White Papers

Table of contents
3 SQL Server High Availability and Disaster Recovery with Dell EMC SC Series | CML1119
Table of contents
Revisions............................................................................................................................................................................. 2
Acknowledgements ............................................................................................................................................................. 2
Executive summary ............................................................................................................................................................. 4
1 Overview of Dell EMC SC Series tools for HA/DR ....................................................................................................... 5
1.1 Snapshots ........................................................................................................................................................... 5
1.2 Replay Manager ................................................................................................................................................. 5
1.3 Live Migration ..................................................................................................................................................... 6
1.4 Online Thin Import .............................................................................................................................................. 6
1.5 Replication .......................................................................................................................................................... 6
1.5.1 Asynchronous replication ................................................................................................................................... 7
1.5.2 Semi-synchronous replication ............................................................................................................................ 7
1.5.3 Synchronous replication ..................................................................................................................................... 7
1.5.4 Understanding replication requirements ............................................................................................................. 7
1.6 Synchronous Live Volume w/Auto Failover ........................................................................................................ 8
2 Comparing Microsoft SQL Server and SC Series availability features ........................................................................ 9
2.1 High availability features ..................................................................................................................................... 9
2.1.1 Asynchronous replication or log shipping ........................................................................................................... 9
2.1.2 Asynchronous replication or Always On Availability Groups .............................................................................. 9
2.1.3 Synchronous replication or Always On Availability Groups ................................................................................ 9
2.2 Other considerations ........................................................................................................................................ 10
2.2.1 Expertise ........................................................................................................................................................... 10
2.2.2 Licensing ........................................................................................................................................................... 10
2.2.3 Compatibility ..................................................................................................................................................... 10
2.2.4 Network ............................................................................................................................................................. 11
3 Preparing SQL Server for SC Series Replication ....................................................................................................... 12
3.1.1 Volume and file selection .................................................................................................................................. 12
3.1.2 Tempdb considerations .................................................................................................................................... 12
3.1.3 Replay Manager ............................................................................................................................................... 12
3.1.4 Database level or instance level protection ...................................................................................................... 12
3.1.5 SQL Server tuning ............................................................................................................................................ 12
3.1.6 Testing .............................................................................................................................................................. 13
3.1.7 Scripting ............................................................................................................................................................ 13
A Additional resources ................................................................................................................................................... 14
A.1 Technical support and resources ..................................................................................................................... 14
A.2 Related resources ............................................................................................................................................ 14