White Papers

5 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
6.1 Snapshot Smart Copy restore options ...................................................................................................................... 20
6.2 In-Place database restore ............................................................................................................................................ 22
6.3 SQL Server database restore with Apply Logs option ............................................................................................ 23
6.4 Restore as New or “Side-by-Side” database restore............................................................................................... 25
6.5 Selective restore of SQL Server databases ............................................................................................................... 26
6.6 Clone Smart Copy restore options ............................................................................................................................ 28
7 ASM/ME Operations in a Windows Server Cluster ............................................................................................................. 29
7.1 Protecting clustered SQL Server databases ............................................................................................................. 29
7.2 Recovering SQL Server Data in a failover cluster .................................................................................................... 29
7.2.1 Restore All and Restore selected database .............................................................................................................. 30
7.2.2 Restore as New and Mount ......................................................................................................................................... 30
7.2.3 Restore as New – Drive Letter Option ...................................................................................................................... 31
7.2.4 Restore All as New – Mount Point Option ............................................................................................................... 34
8 Advanced Operations with SQL Server Databases ............................................................................................................ 36
8.1 SQL Server Database Restore to a New Server ....................................................................................................... 36
8.2 SQL Server Database Distribution using Template Databases .............................................................................. 39
8.3 Step by Step Template Database Creation .............................................................................................................. 40
8.4 SQL Server Database Replication using Smart Copies ........................................................................................... 43
8.5 Data Mining or Offloading Operations with Smart Copy Replicas ...................................................................... 44
8.6 SQL Server Database Disaster Recovery with Smart Copy Replicas .................................................................... 46
8.7 Disaster Recovery with Failback Capabilities ........................................................................................................... 46
8.8 Off-Host Backup and Recovery ................................................................................................................................. 47
9 Summary ................................................................................................................................................................................... 49
A Command line options ........................................................................................................................................................... 50
A.1 Scripting ASM/ME v3.1 and Later ................................................................................................................................ 50
Technical Support and Customer Service .................................................................................................................................. 52