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

• The remote-site volume is not usually mounted. When necessary, it will be mounted at the G: drive
on the backup server.
• The SQL Server data files and transaction log files are stored in the same directory structures on
the local and remote sites.
• Use Operation_A as the operation ID.
Backing up an SQL Server database to a remote site
The example provided below explains the operation used to back up a file system to a remote site.
Procedures at the local site and remote site are explained separately.
Operation at the local site
1. Check the volume to be backed up and its generation identifier.
To check the information, execute the drmsqldisplay command on the database server.
DBServer > drmsqldisplay default -cf
INSTANCE: default
T DB OBJECT FILE FS DG DEVICE COPY-GROUP COPY-FUNC
GEN-NAME
D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk1 BC01,SQL01 Business Copy
local_0
- - - - - - - BC01,SQL01 Business Copy
local_0
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1 BC01,SQL01 Business Copy
local_0
- - - - - - - BC01,SQL01 Business Copy
local_0
D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk2 Cnt Ac01,SQL11 Continuous
Access Software remote_0
- - - - - - - Cnt Ac01,SQL11 Continuous
Access Software remote_0
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk2 Cnt Ac01,SQL11 Continuous
Access Software remote_0
- - - - - - - Cnt Ac01,SQL11 Continuous
Access Software remote_0
DBServer >
2. Back up the database to the remote-site secondary volume.
To back up the database to the remote-site secondary volume, execute EX_DRM_SQL_BACKUP,
in which remote_0 is specified as the backup destination generation identifier, on the database
server.
DBServer > EX_DRM_SQL_BACKUP Operation_A -rc remote_0
CLI User Guide 327