HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 344)

1. Back up the SQL Server database to the secondary volumes.
To perform an online backup of the SQL Server database, execute the drmsqlbackup command.
PROMPT> drmsqlbackup SQL1
KAVX0001-I The drmsqlbackup command will now start.
KAVX1017-I SQL Server information is being collected now.
KAVX1207-I Backing up the database...
KAVX0040-I The backup ID has been assigned as follows:
Backup ID = 0000000001
KAVX0002-I The drmsqlbackup command will now end.
PROMPT>
When you execute this command, the backup information is registered into the backup catalog
on database server 1 under a new backup ID (the next unused ID). The following assumes that
the new backup ID is
0000000001 .
2. Check the backup execution results.
To confirm that backup to the secondary volumes finished successfully, execute the drmsqlcat
command.
PROMPT> drmsqlcat SQL1
INSTANCE: SQL1
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: SQL1
ORIGINAL-ID: 0000000001
START-TIME: 2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00
HOSTNAME: SQL1
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M DB1 METAFILE C:\METADIR\Meta1 C: - - -
D DB1 DATAFILE D:\SQL\data1 D: - Harddisk1 SQL001,B001
- - - - - - - SQL001,B001
T DB1 TRANSACT E:\SQL\tlog E: - Harddisk2 SQL002,B001
- - - - - - - SQL002,B001
PROMPT>
3. Export the backup information to a temporary file.
You must copy to database server 2 the information pertaining to the operations performed in
backing up the primary volumes to the secondary volumes. To export the information pertaining
to the backup operations to the temporary file
C:\temp\EX-FILE1.drm , execute the
drmdbexport command.
PROMPT> drmdbexport 0000000001 -f C:\temp\EX-FILE1.drm
KAVX0001-I The drmdbexport command will now start.
KAVX0002-I The drmdbexport command will now end.
PROMPT>
Operation for SQL Server databases 344