12.6 SQL Server Associated Commands

This section explains the commands with which the backup and restore of SQL Server databases are performed.

It is necessary that only a user belonging to the Administrators group execute an SQL Server associated command.

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

Note

Operating environment for command execution

The table below lists the requirements for the operating environment in which to execute the different commands.

Table 12.29 Operating environment when executing SQL Server associated commands
Command	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 intra-server replication 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

In cluster operation, execute a command by taking the following steps:

If necessary, specify the logical node name to the transaction in the environment variable SWSTGNODE. Specify the environment variable as follows:
```
set SWSTGNODE=logical-node-name
```
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 12.30 Commands when cluster operation is used
Command	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	-

Note

SQL Server associated commands do not support the SnapOPC function.