HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

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 StorageWorks P9000 Replication Manager Software
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 “PrecautionsPrecautions
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
• The maximum number of databases that the drmsqlbackup command can back up at one time
is 64. To back up 65 or more databases, perform separate executions of the drmsqlbackup
command.
• 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.
CLI User Guide 275