ETERNUS SF AdvancedCopy Manager V16.9.1 Operation Guide

14.5 SQL Server Associated Commands

The commands described in this section must be executed by users who have the following privileges.

• Windows Roles

  • When domain authentication is used: (It is necessary to assign all of the following roles to the account.)

    Administrators, Domain Admins, Domain Users, Enterprise Admins, Group Policy Creator Owners, Schema Admins

  • When local accounts authentication is used:

    Administrators

• SQL Server Roles

  sa(SystemAdmin privileges)

The commands used by the backup management function and the replication management function are different. Refer to "14.5.1 Backup Management Commands" when you use the backup management function. Refer to "14.5.2 Replication Management Commands" when you use the replication management function.

Note

The operating environment required for command execution is shown in the table below.

Table 14.15 Operating Environment Required for Executing SQL Server Associated Commands

Command Name	Operating Environment of AdvancedCopy Manager
swstbackup_sqlsvr	In EC operation, Windows services required by the Managed Server must be running.
swstrestore_sqlsvr	-
swsrpbackup_sql	In replication on single server and EC operation, Windows services required by the Managed Server must be running. For inter-server replication, Windows services required by the Managed Servers in communication must be running (except when the -m or -t option is specified).
swsrprestore_sql	-

Note

• In Cluster Operation, there is the following note.

  Execute a command by taking the following steps:

  1. If necessary, specify the logical node name to the transaction in the environment variable SWSTGNODE. Specify the environment variable as follows:

     set SWSTGNODE=logicalNodeName

  2. Execute the command.

  The table below lists the commands available in cluster operation, whether environment variables must be configured, and the nodes on which commands are executable. For notes and cautions on command execution, refer to the Remarks column.

  Table 14.16 Commands When Cluster Operation Is Used

  Command Name	Environment Variable	Command Execution Node	Remarks
  swstbackup_sqlsvr	Required	Transaction operation node	-
  swstrestore_sqlsvr	Required	Transaction operation node	-
  swsrpbackup_sql	Required	Transaction operation node	-
  swsrprestore_sql	Required	Transaction operation node	-

• SQL Server associated commands do not support the SnapOPC function.