Operation at the remote site – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 330

Advertising
background image

4.

Export the backup information to temporary files.

To perform backup from the secondary volume to tape, you need to copy information about the
backup operations from the primary volume to the secondary volume, to the backup server. To
export the information pertaining to the backup operations to temporary files, execute

EX_DRM_DB_EXPORT

. The temporary files are stored in the temporary directory for extended

commands, on the database server.

DBServer > EX_DRM_DB_EXPORT Operation_A

5.

Transfer the temporary files to the backup server.

Collectively transfer the temporary files from the database server to the backup server. The
temporary files are stored in the temporary directory for extended commands, on the backup
server.

DBServer > EX_DRM_FTP_PUT Operation_A -server BKServer -user admin -password password

Operation at the remote site

1.

Import the temporary files that have been transferred from the local-site database server, to the
backup catalog on the backup server.

To import the temporary files, execute

EX_DRM_DB_IMPORT

on the backup server.

BKServer > EX_DRM_DB_IMPORT Operation_A

2.

Check that the import operation has been performed correctly.

To confirm that backup information with the date of the backup from the primary volume to the
secondary volume has been correctly imported to the backup server, execute the

drmsqlcat

command on the backup server.

BKServer > 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 G:\MSSQL\meta\0000000001_0000000005.dmp - - - -

D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk1

SI01,SQL01

- - - - - - -

SI01,SQL01

T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1

SI01,SQL01

BKServer >

3.

Back up the data of the secondary volume to tape.

To back up the data of the secondary volume, execute

EX_DRM_TAPE_BACKUP

on the backup

server.

BKServer > EX_DRM_TAPE_BACKUP Operation_A

When backup is performed in this example, information on this backup operation is entered in
the backup catalog, with a new backup ID

0000000002

.

Operation for SQL Server databases

330

Advertising