HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

Figure 94 System configuration for backing up and restoring an SQL Server database between a local
site and a remote site
The system prerequisites for this example are as follows:
• The system includes a local-site database server (server name: DBServer) and a remote-site
backup server (server name: BKServer) to which a tape device is attached.
• FTP service is active on the remote-site backup server and is configured to ensure that any user
who has logged in to the operating system running on each file server can log in to the FTP server
and transfer files. The FTP user ID is admin, and the FTP user password is password.
• SQL Server is installed on the remote-site backup server (BKServer) to ensure that, when a
problem occurs in the local-site storage system, the backup server can be used as a database
server.
• The local-site primary volume is mounted at the G: drive on DBServer.
• The copy group named Cnt Ac01,SQL11 contains a Continuous Access Software (usual operation
is in the pair status).
• The SQL Server data files and transaction log files are included in the Continuous Access Software
or Continuous Access Journal volume (usual operation is in the pair status) named Cnt
Ac01,SQL11.
• The copy group named BC01,SQL01 includes a Business Copy pair.
• The system is configured to ensure that the generation identifier of the remote-site backup destination
will be remote_0.
Operation for SQL Server databases326