Home » Dell Manuals » Servers » Dell EqualLogic PS6210XV » Manual Viewer

Dell EqualLogic PS6210XV EqualLogic Auto-Snapshot Manager/Microsoft Edition Ve - Page 74

Using ASM/ME with SQL Server, SQL Server Version Compatibility, Create and Schedule SQL Smart Copies

View all Dell EqualLogic PS6210XV manuals

Add to My Manuals
Save this manual to your list of manuals

Page 74 highlights

7 Using ASM/ME with SQL Server ASM/ME supports SQL Server 2014, 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 Snapshot copy or full Restore Options • Mount • Restore selected databases. (Apply logs option also available for the full backup type.) • Restore all • Restore as new Clone copy or full • Mount 74 Using ASM/ME with SQL Server

Section	Page
About This Guide	3
Revision History	3
Audience	3
Related Documentation	3
Dell Online Services	3
Technical Support and Customer Service	3
Contacting Dell	3
Dell EqualLogic Auto-Snapshot Manager/Microsoft Edition Version 5.3 User's Guide	4
Introduction to ASM/ME	9
Functions Provided By ASM/ME	9
Supported Applications	9
HIT Groups and Multiple Machine Management	9
ASM/ME Smart Copies	10
Smart Copy Types	10
Smart Copy Operations for Template and Thin Clone Volumes	10
Robust Data Recovery	11
Think-Provisioning a Volume	11
SAN Data Copy Offload	11
Scripts and Command Generation	12
Alerts and Event Notification	12
Remote Installations	13
Failover Cluster Support	13
ASM/ME and the Virtual Snapshot Service	13
Configure ASM/ME	15
PS Series Group Requirements	15
Windows Computer Requirements	16
Required Access Controls	16
VSS/VDS Service Access to the Group	17
Access to Volumes and Snapshots	17
iSCSI Target Connections	18
Volume Mount Point and Drive Letter Assignments	18
Mount Point Constraints in Cluster Environments	18
ASM/ME Settings	19
General Settings	19
About the Backup Document Directory	20
Backup Document Directories for Standalone (Non-Clustered) Hosts	21
Backup Document Directories for Clusters and SharePoint Farms	21
Set the Backup Document Directory	21
Managing the ASM Services	21
Notification Settings	21
Configure Notification Settings	22
Alert Settings	22
Configure Alert Settings	24
Verification Settings	24
Configure Verification Settings	24
About PS Group Access Settings	24
PS Group Access Settings	25
Configure PS Group Access	25
VSS/VDS Settings	26
Configure VSS/VDS Access Settings for the Local Host	26
Smart Copy Access	26
Configure Smart Copy Access	26
PowerShell and SMP Access	26
Configure PowerShell/SMP Access	27
MPIO Settings	27
Configure MPIO Settings	27
Configure Failover Policy Settings	28
Configure MPIO Connections Settings	28
Configure the Network	28
Configure the Network Connections	28
ASM/ME Graphical User Interface	29
Start the ASM/ME GUI	29
Callout 1 — Dashboard	29
Callout 2 — Tree Panel	30
Callout 3 — Actions Toolbar	30
Callout 4 — Global Actions Toolbar	30
Callout 5 — Menu Bar	30
Callout 6 — Navigation Area	31
Callout 7 — Status Bar	31
Tree Panel	31
Tree Panel Behavior in Failover Cluster Environments	31
Tree Panel Nodes	31
Tree Panel Icons	33
Group SharePoint Farm Nodes, Clusters, or Host Nodes	34
Assign SharePoint Farms, Clusters, and Host Nodes in the Same SharePoint Farm to a Group	35
Remove SharePoint Farms, Clusters, and Host Nodes From a Group	35
About Aliases	35
Assign an Alias to SharePoint Farm Nodes, Cluster Nodes, or Individual Host Nodes	35
Assign an Alias to a SharePoint Farm Node	35
Assign an Alias to a Cluster Node	36
Assign an Alias to a Host Node	36
Delete an Alias for a SharePoint Farm, Cluster, or Host Node	36
Delete a SharePoint Farm Alias	36
Delete a Cluster Alias	36
Delete a Host Alias	36
Customize Color Themes	36
Change the Color Theme for ASM/ME	36
Change the Color Theme for the Volume View	36
HIT Groups	37
Overview of HIT Groups	37
ASM/ME Operations on HIT Group Members	37
HIT Groups in Non-Cluster Environments	37
HIT Groups in Cluster Environments	38
Multiple Cluster Management — Using a Non-Clustered Host	38
Multiple Cluster Management — Two-Cluster Example	39
Create a HIT Group — Overview	40
Prerequisites for HIT Groups	40
Create a HIT Group With the Add Hosts Wizard	41
Edit ASM/ME Settings on Hosts in a HIT Group	41
General ASM/ME Operations	42
About Volumes	42
View Volume Details	42
About Thin-Provisioning Volumes in HIT/Microsoft	43
Thin-Provision a Volume	43
Operations on Failover Clusters	43
Identifying Cluster Volumes in the ASM/ME GUI	44
About Collections	44
Volume-Based Collections	44
Create a Collection	44
More Collection Operations	45
About Schedules	45
Retained Copies or Replicas	45
Recommendations for Schedule Creation	46
Constraints for Schedules	46
Schedules in Cluster Environments	46
Create a Schedule for Smart Copies	46
Modify a Schedule	46
Delete a Schedule	47
Enable a Schedule	47
Disable a Schedule	47
Schedules for Thin-Provisioning	47
Create a Schedule for Volume Thin-Provisioning	47
About Smart Copies	48
Torn Smart Copies	48
Requirements for Creating Smart Copies	49
Constraints for Smart Copy Operations	50
Create Smart Copies	50
Smart Copy Properties for Volumes	51
Synchronous Replication (SyncRep)	51
Volume Undelete	51
Snapshot Space Borrowing	51
View Available Smart Copies	51
Troubleshooting Unreachable Smart Copies	52
Troubleshooting Broken Smart Copies	52
Troubleshoot Recoverable Smart Copies	52
View Smart Copy Details	52
Smart Copy Validation	52
Deleting Smart Copies	53
Delete Individual Smart Copies	53
Delete All Smart Copies	53
View Backup Documents	53
Importing a Smart Copy	53
Prerequisites for Importing a Smart Copy	53
Import a Smart Copy	54
Import a Smart Copy Within a HIT Group	54
Import a Smart Copy Outside of a HIT Group	54
Restoring Data	54
Mount Smart Copies	55
Prerequisites for Mounting Smart Copies	55
Mount a Snapshot or Clone Smart Copy	55
Mount a Replica Smart Copy	56
Make a Mounted Smart Copy Accessible to Cluster Nodes	56
Restore Data From a Smart Copy	56
Options for Unmounting and Logging Off a Smart Copy	56
Constraints for Unmounting and Logging Off a Smart Copy	57
Prerequisites for Unmounting Smart Copies in a Cluster Environment	57
Unmount and Log Off a Smart Copy	57
View Multipath Information	57
View I/O Details	58
Using ASM/ME with Exchange	59
View Exchange Applications in ASM/ME	59
Exchange 2013 and 2016 Writers	59
Exchange Operations	59
Overview of Exchange Smart Copies	60
Exchange eseutil.exe Utility	60
Recovery Considerations for Exchange	61
Checksum Verification and Soft Recovery	61
Run Checksum Verification and Soft Recovery Immediately	61
Run Checksum Verification and Soft Recovery After Smart Copy Creation	62
Schedule a Global Verification Task for Checksum Verification and Soft Recovery	62
Create or Modify the Global Verification Task	62
Constraints for Global Verification Task	62
Manually Create a Global Verification Schedule	63
Run Checksum Verification and Soft Recovery on a Remote Host	64
Remote Host Checksum Verification and Soft Recovery in a HIT Group	64
Prerequisites for Configuring a Verification Server	64
Configure a Verification Server	65
View Checksum Verification and Soft Recovery Status	65
Checksum Verification and Soft Recovery Logging and Notification	66
Create Exchange Smart Copies	66
Exchange Smart Copy Options	66
Checksum Verification and Soft Recovery for Replicas	67
Schedule Smart Copies for Exchange Components	68
Recover Exchange Data	69
About Exchange In-Place Restore	70
Fully Restore an Exchange Database	71
Prerequisites for Restoring an Exchange Mailbox Database	71
Fully Restore an Exchange Mailbox Database	71
About Creating a Recovery Mailbox Database	71
Prerequisites for Creating a Recovery Mailbox Database	72
Create a Recovery Mailbox Database	72
About the Clone and Restore as New Operation	72
Prerequisites for Clone and Restore As New	72
Clone and Restore As New	73
Using ASM/ME with SQL Server	74
SQL Server Version Compatibility	74
Create and Schedule SQL Smart Copies	74
Restore Options for SQL Server Smart Copies	74
Snapshot Smart Copy Restore Options	75
Clone Smart Copy Restore Options	75
Replica Smart Copy Restore Options	76
Mount a SQL Server Smart Copy	76
Log Off Recently Mounted Smart Copies	76
Restore Selected SQL Server Databases	76
Restore All Databases	77
Restore a Database as New	77
Using ASM/ME with Hyper-V	79
Support for Hyper-V	79
Hyper-V Requirements	79
Hyper-V Supported Configuration	80
Unsupported Configurations	81
Hyper-V Specific Operations	81
Smart Copies for Linux Guest Operating Systems	81
Avoid Torn Smart Copies	81
Hyper-V Collections	81
Smart Copy Schedules for Hyper-V	82
Hyper-V Restore Operations	82
Restore a VM In-Place	82
Selectively Restore a VM	82
Restore a VM as New	82
Cluster Shared Volumes	83
CSVs in a Windows Server 2012 Environment	83
Creating Smart Copies in a CSV-Enabled Cluster	83
Smart Copies of CSVs	84
Smart Copies of CSV Collections	84
Restore Operations in a CSV Environment	84
Restore In-Place in a Cluster	84
Selectively Restoring a VM	84
Restore as New a Snapshot or Clone	84
Clone and Restore As New	85
Using ASM/ME with SharePoint	86
SharePoint Installation Considerations	86
Plan to Install on a SharePoint Farm	86
Example of ASM/ME Installed on a SharePoint Farm	86
Example of a SharePoint Farm with a SQL Cluster	88
Install ASM/ME on a SharePoint Farm	89
About Changes to an Existing SharePoint Farm	89
Remove a HIT Group Host From a SharePoint Farm	90
Add a Writer Host to a SharePoint Farm	90
Change a Writer Host in a SharePoint Farm	90
Change the Writer Host and Disable the VSS Writer in a SharePoint Farm	90
Respond to Changes in a SharePoint Farm	91
View SharePoint Farm Components in ASM/ME	91
SharePoint Smart Copies	92
Create a Smart Copy of an Entire SharePoint Farm	92
Create a Smart Copy of All Content Databases	93
Create a Smart Copy of a Single Database	93
Create a Smart Copy of an SSA	93
Restore Options for SharePoint Smart Copies	94
Availability of SharePoint Data Restoration Operations	96
Mount a SharePoint Smart Copy	96
Restore Selected Databases from a SharePoint Smart Copy	96
Restore a Database In-Place From a SharePoint Smart Copy	97
Restore a Database From a SharePoint Smart Copy as a New Database	97
Restore an SSA From a SharePoint Smart Copy	97
Using the Command Line Interface	99
Introduction to ASMCLI	99
How to Use ASMCLI Commands	100
General Command Syntax	100
ASMCLI Command Summary	100
Command Parameters	101
ASMCLI Commands and Their Syntax	109
ASMCLI -alert	109
ASMCLI -breaksmartcopy	110
ASMCLI -cloneReplica	110
ASMCLI -configureASM	111
ASMCLI -configureCHAP	111
ASMCLI -createCollection	112
ASMCLI -delete	112
ASMCLI -deleteCollection	113
ASMCLI -enumerateiSCSIPortals	113
ASMCLI -enumerateSmartCopies	113
ASMCLI -help	114
ASMCLI -list	114
ASMCLI -modifyCollection	115
ASMCLI -mount	115
ASMCLI -Properties	116
ASMCLI -restore	117
ASMCLI -selectiveRestore	118
ASMCLI -shutdownsystray	118
ASMCLI -shutdownverifier	119
ASMCLI -smart	119
ASMCLI -unmount	121
ASMCLI -verify	122
ASMCLI -version	123
Use a Script to Create Smart Copies	123
Prepare to Create the Script Commands	123
Create the Script Commands	123
Recover a Clustered Volume From a Clone	125
Index	126
A	126
B	127
C	127
D	128
E	128
F	129
G	129
H	129
I	129
L	129
M	130
N	130
O	130
P	130
Q	130
R	130
S	131
T	133
U	133
V	133

Match case Limit results 1 per page

Using ASM/ME with SQL Server

ASM/ME supports SQL Server 2014, 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

•

Restore selected databases. (Apply logs option also

available for the full backup type.)

•

Restore all

•

Restore as new

Clone

copy or full

•

Mount

Using ASM/ME with SQL Server