Users Guide
Table Of Contents
- About This Guide
- Dell EqualLogic Auto-Snapshot Manager/Microsoft Edition Version 5.4 User's Guide
- Introduction to ASM/ME
- Functions Provided By ASM/ME
- Supported Applications
- HIT Groups and Multiple Machine Management
- ASM/ME Smart Copies
- Smart Copy Types
- Smart Copy Operations for Template and Thin Clone Volumes
- Robust Data Recovery
- Thin-Provisioning a Volume
- SAN Data Copy Offload
- Scripts and Command Generation
- Alerts and Event Notification
- Remote Installations
- Failover Cluster Support
- ASM/ME and the Virtual Snapshot Service
- Functions Provided By ASM/ME
- Configure ASM/ME
- PS Series Group Requirements
- Windows Computer Requirements
- Required Access Controls
- VSS/VDS Service Access to the Group
- Access to Volumes and Snapshots
- iSCSI Target Connections
- Volume Mount Point and Drive Letter Assignments
- Mount Point Constraints in Cluster Environments
- ASM/ME Settings
- ASM/ME Graphical User Interface
- Start the ASM/ME GUI
- Tree Panel
- Tree Panel Behavior in Failover Cluster Environments
- Tree Panel Nodes
- Tree Panel Icons
- Group SharePoint Farm Nodes, Clusters, or Host Nodes
- About Aliases
- Customize Color Themes
- HIT Groups
- General ASM/ME Operations
- About Volumes
- Operations on Failover Clusters
- About Collections
- About Schedules
- About Smart Copies
- Restoring Data
- View Multipath Information
- View I/O Details
- Using ASM/ME with Exchange
- View Exchange Applications in ASM/ME
- Exchange Operations
- Overview of Exchange Smart Copies
- Exchange eseutil.exe Utility
- Recovery Considerations for Exchange
- Checksum Verification and Soft Recovery
- Run Checksum Verification and Soft Recovery Immediately
- Run Checksum Verification and Soft Recovery After Smart Copy Creation
- Schedule a Global Verification Task for Checksum Verification and Soft Recovery
- Run Checksum Verification and Soft Recovery on a Remote Host
- View Checksum Verification and Soft Recovery Status
- Checksum Verification and Soft Recovery Logging and Notification
- Create Exchange Smart Copies
- Schedule Smart Copies for Exchange Components
- Recover Exchange Data
- Using ASM/ME with SQL Server
- Using ASM/ME with Hyper-V
- Using ASM/ME with SharePoint
- SharePoint Installation Considerations
- Plan to Install on a SharePoint Farm
- Example of ASM/ME Installed on a SharePoint Farm
- Example of a SharePoint Farm with a SQL Cluster
- Install ASM/ME on a SharePoint Farm
- About Changes to an Existing SharePoint Farm
- Remove a HIT Group Host From a SharePoint Farm
- Add a Writer Host to a SharePoint Farm
- Change a Writer Host in a SharePoint Farm
- Change the Writer Host and Disable the VSS Writer in a SharePoint Farm
- Respond to Changes in a SharePoint Farm
- View SharePoint Farm Components in ASM/ME
- SharePoint Smart Copies
- Restore Options for SharePoint Smart Copies
- Availability of SharePoint Data Restoration Operations
- Mount a SharePoint Smart Copy
- Restore Selected Databases from a SharePoint Smart Copy
- Restore a Database In-Place From a SharePoint Smart Copy
- Restore a Database From a SharePoint Smart Copy as a New Database
- Restore an SSA From a SharePoint Smart Copy
- Using the Command Line Interface
- Introduction to ASMCLI
- How to Use ASMCLI Commands
- General Command Syntax
- ASMCLI Command Summary
- Command Parameters
- ASMCLI Commands and Their Syntax
- ASMCLI -alert
- ASMCLI -breaksmartcopy
- ASMCLI -cloneReplica
- ASMCLI -configureASM
- ASMCLI -configureCHAP
- ASMCLI -createCollection
- ASMCLI -delete
- ASMCLI -deleteCollection
- ASMCLI -enumerateiSCSIPortals
- ASMCLI -enumerateSmartCopies
- ASMCLI -help
- ASMCLI -list
- ASMCLI -modifyCollection
- ASMCLI -mount
- ASMCLI -Properties
- ASMCLI -restore
- ASMCLI -selectiveRestore
- ASMCLI -shutdownsystray
- ASMCLI -shutdownverifier
- ASMCLI -smart
- ASMCLI -unmount
- ASMCLI -verify
- ASMCLI -version
- Use a Script to Create Smart Copies
- Recover a Clustered Volume From a Clone
- Index
Using ASM/ME with SQL Server
ASM/ME supports SQL Server 2016 and 2017. See the Dell EqualLogic Host Integration Tools for Microsoft Release Notes for
specific release versions.
Certain ASM/ME operations are specific to SQL Server and some operations behave differently when Smart Copy sets include
SQL Server components. ASM/ME operations that are not specific to SQL Server are described in General ASM/ME
Operations.
NOTE: ASM/ME does not support creating Smart Copies of SQL Availability Groups.
Topics:
• SQL Server Version Compatibility
• Create and Schedule SQL Smart Copies
• Restore Options for SQL Server Smart Copies
SQL Server Version Compatibility
Although it is not detected during installation, ASM/ME verifies the compatibility of the installed version of SQL Server. If
ASM/ME detects an unsupported version of SQL Server, a red arrow displays next to the application in the ASM/ME console.
The SqlServerWriter node (under the Applications node) is disabled if the installed version and service pack level of SQL Server
are unsupported.
See the product requirements in the Host Integration Tools for Microsoft Installation and User’s Guide.
See Using ASM/ME with Hyper-V if you intend to run SQL Server with a Hyper-V virtual machine. In some configurations,
certain ASM/ME operations are constrained.
Create and Schedule SQL Smart Copies
● If you use ASM/ME to create a Smart Copy set or a schedule that includes multiple SQL Server components (multiple
databases sharing similar volumes), ASM/ME warns you that during restore operations, all components are set offline even if
you need to restore only one component.
● Limit the number of databases in a Smart Copy collection to 34 or fewer. If you have more than 34 databases, spread them
among multiple hosts. For more information, see Knowledge Base article: support.microsoft.com/kb/943471.
● The procedures for creating and scheduling Smart Copies are the same as the general operations described in General
ASM/ME Operations.
● As a best practice, do not put system databases (Master, Model, MSDB, and TempDB) on the same volumes as user
databases. Keeping these databases separate allows for independent recovery of the user content or the system. It also
prevents problems caused by changes to the system databases while restoring user content.
Restore Options for SQL Server Smart Copies
The following table summarizes available SQL Server restore options and Backup Types according to the Smart Copy Type.
Table 27. SQL Server Data Restore Options by Smart Copy Type
Smart Copy Type Backup Type Restore Options
Snapshot copy or full
● Mount
7
Using ASM/ME with SQL Server 79