HP XP Array Manager Software - Manual (Page 329)

• 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 SI01,SQL01 Business Copy
local_0
- - - - - - - SI01,SQL01 Business Copy
local_0
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1 SI01,SQL01 Business Copy
local_0
- - - - - - - SI01,SQL01 Business Copy
local_0
D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk2 TC01,SQL11 Continuous
Access Software remote_0
- - - - - - - TC01,SQL11 Continuous
Access Software remote_0
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk2 TC01,SQL11 Continuous
Access Software remote_0
- - - - - - - TC01,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
3. Check that backup was performed properly.
To check the backup information, execute drmsqlcat on the database server.
DBServer > drmsqlcat default
INSTANCE: default
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000001
START-TIME: 2004/08/05 10:00:00 END-TIME: 2004/08/05 10:03:00 HOSTNAME: DBServer
T DB OBJECT FILE FS DG DEVICE
COPY-GROUP
M UserDB1 METAFILE F:\MSSQL\meta\0000000131_0000000005.dmp - - - -
D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk1
TC01,SQL11
- - - - - - -
TC01,SQL11
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1
TC01,SQL11
DBServer >
Application Agent CLI User Guide 329