HP StorageWorks Storage Mirroring Recover User's Guide (T5437-96021, November 2010)
Storage Mirroring Recover requirements Page 52 of 677
SQL protection requirements
In addition to the general application requirements, you must also meet the following
requirements to protect SQL.
l SQL versions—Storage Mirroring Recover can protect Microsoft SQL Server or
Express 2000 with Service Pack 4 or later, Server or Express 2005, or Server or
Express 2008, with the following requirements and limitations.
l If you are using Windows 2008, you can protect SQLServer or Express 2005
or 2008. SQLServer or Express 2000 is not supported on Windows 2008.
l You should use the same version, service pack, and architecture (32-bit or
64-bit) of SQL Server on both the source and target servers. The only
exceptions is in database only protection mode you. In this case, you can use
a newer version of SQL Server on the target server, or you may have a 32-bit
source and a 64-bit target. For example, you may want migrate from SQL
Server 2000 on the source to SQL Server 2005 on the target, or migrate data
from a 32-bit source to a 64-bit target. However, you cannot failback using
different versions of SQL Server on the source and target.
l If you are using SQLExpress 2008, you will need to enable and start the
SQL Browser Service. By default, this service is set to disabled. Additionally,
you will need to enable TCP/IP to accept remote connections. To do this,
launch the SQL Server Configuration Manager. Expand SQL Server
Network Configuration, and under Protocols for MSSQLSERVER enable
TCP/IP.
l If you are using SQL Express 2005, you will need to enable named pipes
and TCP/IP to accept remote connections. To do this, launch the SQL Server
Configuration Manager. Expand SQL Server 2005 Network Configuration,
and under Protocols for MSSQLSERVER enable Named Pipes and
TCP/IP.
l If you are using SQL Express 2000, you will need to enable named pipes
and TCP/IP to accept remote connections. To do this, run svrnetcn.exe,
which is located in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn
directory.
l Server and network configuration—The following requirements and limitations
apply to your SQL server and network configuration.
l You can use a one-to-one configuration for SQL protection. You can also use
a many-to-one configuration, however protection will be database mode only.
You cannot use a one-to-many or chained configuration.