Backing up the transaction log backup file – HP Serveur lame HP ProLiant BL465c Gen8 User Manual
Page 320
FTP_HOME_DIR=C:\FTP_ROOT
FTP_SUB_DIR=script
SET_DRM_HOSTNAME=1
•
The operation definition file used to back up the file system is named
FS1
. The backup target is
the G drive that contains the transaction log backup file storage directory.
Contents of
_FS1.dat
:
BACKUP_OBJECT=FILESYSTEM
DB_SERVER_NAME=FILESERV1
INSTANCE_NAME=G:
TARGET_NAME=
FTP_HOME_DIR=C:\FTP_ROOT
FTP_SUB_DIR=script
SET_DRM_HOSTNAME=1
Backing up the transaction log backup file
1.
Back up the transaction logs.
To back up transaction logs, execute
EX_DRM_SQL_TLOG_BACKUP
on the database server.
DBServer > EX_DRM_SQL_TLOG_BACKUP SQL1 -target DB1
DBServer >
2.
Check the backup ID that identifies the start point for the transaction logs.
To check the backup ID that identifies the start point for the transaction logs, execute the
drmsqllogbackup
command with the instance-name
-v BACKUP-ID
option specified.
DBServer > drmsqllogbackup SQL1 -v BACKUP-ID
ORIGINAL-ID BACKUP_ID DB
0000000002 0000000002 DB1
DBServer >
3.
Check the contents of the transaction logs that have been backed up.
To check the contents of the transaction logs that have been backed up, execute the
drmsqllogbackup
command with the instance-name
-target
database-name
-v
option
specified.
DBServer > drmsqllogbackup SQL1 -target DB1 -v
# ORIGINAL-ID: 0000000002 BACKUP-ID: 0000000002
[DB1]
G:\LogBackup\DB1_20021106010100_0001.bk
G:\LogBackup\DB1_20021106010110_0002.bk
DBServer >
Operation for SQL Server databases
320