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

• Make sure that the previous backup information has been deleted.
Use the
drmsqlcat command to confirm that the backup information has been deleted. To delete
the backup information, use the drmresync command.
• Make sure that the status of the copy group for which operations are to be performed is
PVOL_PAIR .
Use the RAID Manager pairdisplay command to confirm the status of the copy group.
• If you are using HP P9500, HP XP24000, HP XP20000, XP12000/XP10000/SVS200, or the
XP1024/XP128 series, make sure that the Quick Split option is enabled.
If the Quick Split option of the storage system is not on, making the SQL Server database static is
canceled in the PVOL_COPY status. Making a database static means that only disk writing oper-
ations are temporarily stopped, without stopping SQL Server database updates. When making
the database static is canceled, the backup data of the secondary volume might become corrupted.
Setting up the dictionary map synchronization option for SQL Server database
backup
If you specify that the dictionary map should be updated asynchronously, you can shorten the time
required for backup command execution. If you want to shorten the time for backup command
execution, specify the following parameter.
Note that, if you specify that the dictionary map files be updated asynchronously, you need to
periodically back up the dictionary map files because they are susceptible to collapse if an unexpected
server shutdown, or similar event, occurs during command execution.
Table 15 Parameter in init.conf (dictionary map synchronization option)
Specifiable values
(default)
Description Parameter
YES or NO
( YES )
• Specifies whether the dictionary map should be up-
dated synchronously or asynchronously. If
YES is spe-
cified, the dictionary map will be updated synchron-
ously. If
NO is specified, the dictionary map will be
updated asynchronously.
• Generally, this parameter should be set to YES . If you
need to specify NO (e.g., when the time required for
backup must be reduced for a particular reason), per-
form adequate checking before starting operation.
DRM_DB_SYNC
Setting up the recovery option for SQL Server database backup
You can specify whether to check the SQL Server database integrity when the drmsqlrecover
command is executed, using the following parameter.
Table 16 Parameter in init.conf (recovery option)
Specifiable values
(default)
Description Parameter
YES or NO
( NO )
Specify YES if you want to check database integrity when
the drmsqlrecover command is executed. If nothing or
a value other than YES is specified, integrity will not be
checked.
SQL_CHECKDB
Preparation for using Application Agent 110