Top
ETERNUS SF AdvancedCopy Manager 14.2 Operator's Guide

11.6.1 Backup Management Commands

Swstbackup_sqlsvr and swstrestore_sqlsvr are used in the backup operation of an SQL Server by the backup management function.

11.6.1.1 swstbackup_sqlsvr (SQL Server backup execution command)

NAME

swstbackup_sqlsvr - backup of SQL Server databases


SYNOPSIS

program-directory\bin\swstbackup_sqlsvr [-Xserver Server-Name] [-Xinstance Instance-Name] [-Xdevmap Device-Map-File] [-suspend|-T] DB-Name-1 DB-Name-2,,,DB-Name-i

DESCRIPTION

This command backup SQL Server databases. The command, in cooperation with SQL Server, performs a copy of data on the target database volumes on to backup volumes by executing swstbackup (Backup execution command).

When swststartsync (Backup synchronous processing start command) is executed in advance of the backup synchronous processing and the Chapter 5 Backup Process That Uses the Suspend/Resume Function is used for synchronous high-speed backup, execute the backup command with -suspend specified and suspend the backup synchronous processing.

The database backup history information will be stored in msdb of SQL Server. The database volume backup history information will be stored in the management files of AdvancedCopy Manager.


OPTIONS

-Xserver Server-Name

Specifies the virtual server name of a connected SQL Server in the case of cluster operation. In the case of operation without cluster, this option need not be specified.

-Xinstance Instance-Name

Specifies a connection instance. Specify an instance name in the operand. If this option is not specified, connection will be made to the default instance.

-Xdevmap Device-Map-File

Specifies performing the backup to a specified backup volume. Specify a device map file name that describes combinations of database volumes and destination backup volumes. If this option is not specified, the target backup volume will be automatically selected. Specify a device map file name by using an absolute pathname.

-suspend

This results in synchronous high-speed backup using the Chapter 5 Backup Process That Uses the Suspend/Resume Function.

-T

Specifies that the differential snapshot high-speed backup is to be executed.
This option cannot be specified during synchronous processing.
This option is valid only for copying within a cabinet when the ETERNUS disk storage systems support the QuickOPC function.
For snapshot high-speed backup without specifying this option, ordinary snapshot processing (i.e., OPC without using the QuickOPC function) is started. This option must always be specified to perform a backup operation using differential snapshots.


OPERANDS

DB-Name,,,DB-Name-i(i=1,2,,,,64)

Specifies database names. Delimit by a single blank or the tab character and specify the database names when you specify two or more databases. No more than 64 database names can be specified.


EXIT STATUS

=0:Completed successfully

>0:Terminated abnormally


EXAMPLES

NOTES

11.6.1.2 swstrestore_sqlsvr (SQL Server restore execution command)

NAME

swstrestore_sqlsvr - restores of SQL Server database.


SYNOPSIS

program-directory\bin\swstrestore_sqlsvr [-Xserver Server-Name] [-Xinstance Instance-Name] [-Xnolog] -Xmeta Meta-File-Name DB-Name

DESCRIPTION

This command restores a SQL Server database. Enter this command after restoring database files using swstrestore (Restore execution command). This command recreates a database from restored database files. To perform recovery after this command has been executed, apply logs using Enterprise Manager/Management Studio or Transact-SQL.


OPTIONS

-Xserver Server-Name

Specifies the virtual server name of a connected SQL Server in the case of cluster operation. In the case of operation without cluster, this option need not be specified.

-Xinstance Instance-Name

Specifies a connection instance. Specify an instance name in the operand. If this option is not specified, connection will be made to the default instance.

-Xnolog

Specifies restoring a DB to a backup point, without applying logs. If this option is not specified, the DB will be restored to a backup point but cannot be used until logs are applied to it. Apply logs using Enterprise Manager/Management Studio or Transact-SQL.

-Xmeta Meta-File-Name

Specifies a metadata file name, using an absolute pathname. A metadata file will be stored as "db-name.swst-dmp" in the same folder as the primary data file. To confirm file identification numbers of database files, use the Transact-SQL "USE DB-Name EXEC SP_HELPFILE". After this command closes, the metadata file is deleted.


OPERANDS

DB-Name

Specifies a database name.


EXIT STATUS

=0:Completed successfully

>0:Terminated abnormally


EXAMPLES

NOTES