HP StorageWorks Storage Mirroring Recover User's Guide (T5437-96008, November 2009)

184 of 739
SQL instance (default)
Select SQL Instance protection mode to replicate all of the SQL program and data files
(except the \binn directory) to the target SQL server. This will allow the clients to access
your production SQL Server data and functionality on the target in the event of a failure.
SQL Instance protection mode requires that the source and target servers both have the
exact same version of SQL (major and minor versions) as well as similar logical drive
structures (the target must have at least the same logical drives as the source where
SQL program and data files are stored). Certain user databases can be de-selected, but
the System databases (except for tempdb) are required.
Note:
● If you are protecting SQL named instances, both the source and target
SQL Servers must have named instances with the exact same name
installed prior to configuring protection.
● When using named instances, all named instances will appear in the
Protected Databases area. You can either de-select an entire instance,
or select specific databases within each instance.
● By default, the TcpPort on the source named instance will be different
than the TcpPort on the target named instance. However, the Application
Manager will still be able to work and there is no need for any additional
configuration.
● If you need to reduce the amount of mirroring and replication traffic, you
may choose to deselect the tempdb database if it is not necessary.
You can also select non-application specific data under the Volumes folder.
Note:
If Override Generated Rules is selected on the Advanced tab, this control will
be disabled.
To refresh the tree view to show new source directories or files that may have been
added or removed, select the logical node, then click the Refresh button. If a node in the
volumes branch is selected, then the items under that node will be refreshed.
Database only
The Database Only mode is intended for advanced users only.
Select Database Only protection mode to replicate only the .mdf, .ldf, and .ndf files to the
target server. The selected database(s) will be attached to the target SQL Server upon
failover, allowing clients to access the underlying data.
You can also select non-application specific data under the Volumes folder.