HP XP P9000 Replication Manager Software 7.6.1-00 Application Agent CLI User Guide

Figure 95 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 TC01,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 TC01,SQL11.
• The copy group named SI01,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.
• The remote-site volume is not usually mounted. When necessary, it will be mounted at the G: drive
on the backup server.
Operation for SQL Server databases330