Manualshelf

HP StorageWorks Storage Mirrioring Application Manager user's guide (T2558-96322, April 2009)

ManualsBrandsHP ManualsSoftwareHP StorageWorks Storage Mirroring Software Virtualization Media Kit
41424344454647484950
5 - 1
Protecting a SQL
Server
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 the same SQL service packs or patches that were installed on the source. 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 be assigned prior
to running the Application Manager.
You should use the same version and service pack of SQL Server on both the source and target
servers.
If you are using clusters, you will need to pre-configure the SQL instances on the target using
any combination of default and/or named instances to match what is on the source.
3. Install Storage Mirroring on the source and target SQL servers. See the Storage Mirroring
Getting Started guide for more information.
4. Install the Application Manager on page 2-1
5. Select a task on page 5-1
6. Select a domain on page 5-2
7. Select source and target servers on page 5-3
8. (Optional) Configure protection settings on page 5-5
9. Validate the Configuration on page 9-1
To protect your SQL server, you will complete the following steps:
1. Enable protection on page 10-1
2. Monitor protection status on page 10-2
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 11-1.
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, 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 Application Manager for SQL by using the command line
/sql option
(
dtam /sql).