HP XP Array Manager Software - Manual (Page 277)

6 Operation for SQL Server databases
This chapter describes how to operate Application Agent when backing up an SQL Server database,
focusing on actual procedures. The descriptions in this chapter apply to the Application Agent CLI.
For details on setting up commands, see the .HP XP7 Replication Manager Application Agent CLI
Reference Guide
Backing up and restoring an SQL Server database
This section provides notes on backing up and restoring an SQL Server database.
For notes on operations that do not depend on a particular database, see “ Precautions on
operations ” on page 225.
Precautions when backing up and restoring a database
• When specifying the -target or -f option with the drmsqlbackup command, specify all
databases which are contained in the same logical volume. The command will result in an error
if all databases are not specified.
• When executing the drmsqlrestore command for an SQL Server database for which the name
is changed, be sure to first detach the database to be restored. If you perform restoration operations
without detaching the SQL Server database, the
drmsqlrestore command will not terminate
normally, and you may not be able to use the database after it has been restored.
• You can also specify the original ID for the backup ID of the drmsqllogbackup command. In
this case, add 0: to the beginning of the original ID, and specify it as an argument of the command,
as you would with the backup ID. You can use this functionality when the target backup catalog
has been accidentally deleted, and the backup ID cannot be determined. The following are usage
examples:
1. To view backup information for the transaction log executed for the original ID 0000000001 :
PROMPT> drmsqllogbackup 0:0000000001 -v
2. To delete backup information for the transaction log executed for the original ID 0000000001 :
PROMPT> drmsqllogbackup 0:0000000001 -d
• One execution of the drmsqlbackup command can back up a maximum of 64 databases. If
you want to back up 65 or more databases, execute the drmsqlbackup command more than
once.
• Do not access the operation-target volume (for example, by using Windows Explorer) while a
backup or restoration command is being executed in a Veritas Cluster Server for Windows envir-
onment. Doing so might prevent a cluster resource from being switched offline, and might thereby
cause an error to occur in the backup or restoration command.
Application Agent CLI User Guide 277