HP Storage Mirroring V5 Software - Manual (Page 47)

HP StorageWorks Storage Mirroring Application Manager user’s guide 37
5 Protecting a SQL Server
SQL configuration workflow
To configure protection for your SQL servers using Application Manager, you will complete the following steps:
1. Install SQL on the source server and apply any SQL service packs or patches. Use the default installation
options for SQL.
2. Install SQL on the target, verifying that the installation location for the target is the same as the source.
Apply any SQL service packs or patches. Use the default installation options for SQL with the following
considerations:
• The target must be a unique installation (that is, two SQL servers must be available for a protection pair)
• Logical drive mapping must be the same on the source and target, and must assigned prior to running
the Application Manager.
3. Install Storage Mirroring on the source and target SQL servers. See the Storage Mirroring Getting Started
guide for more information.
4. ” Install the Storage Mirroring Application Manager ” on page 9
5. ” Select a task ” on page 37
6. ” Select a domain ” on page 38
7. ” Select source and target servers ” on page 39
8. (Optional) ” Configure protection settings ” on page 41
9. ” Validate the Configuration ” on page 87
To protect your SQL server, you will complete the following steps:
1. ” Enable protection ” on page 89
2. ” Monitor protection status ” on page 90
In the event of a failure, you will need to perform some additional tasks. These tasks are described in ” Failover,
Failback, and Restoration ” on page 95.
Select a task
To protect a SQL server, open the Application Manager ( Start, Programs, Storage Mirroring, Application
Manager ), then on the Tasks area on the left pane of the Storage Mirroring Application Manager, select Protect
SQL Server . The Manage SQL page will appear in the right pane. Make sure that the Setup tab is in view.
NOTE: You can also launch Storage Mirroring Application Manager for SQL by using the command line
/SQL
option (
DTAM /SQL
).