Swstbackup_sqlsvr and swstrestore_sqlsvr are used in the backup operation of an SQL Server by the backup management function.
NAME
swstbackup_sqlsvr - backup of SQL Server databases
SYNOPSIS
<program-directory>\bin\swstbackup_sqlsvr [-Xserver serverName] [-Xinstance instanceName] [-Xdevmap deviceMapFile] [-suspend|-T] dbName-1 dbName-2,,,dbName-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 the 14.1.2.1 swstbackup (Backup Execution Command)command.
When the swststartsync command is executed in advance of the backup synchronous processing and the "Chapter 5 Backup Operation Using Suspend/Resume Function" is used for synchronous high-speed backup, execute the backup command with -suspend option specified and suspend the backup synchronous processing.
The database backup history information is stored in msdb of SQL Server. The database volume backup history information is stored in the backup management lists of AdvancedCopy Manager.
When using WSFC for cluster operation in a Windows environment, this command performs automatic configuration of the maintenance mode of the physical disk resources to which the volume belongs with pre- and post-processing. For more information, refer to "15.1.7.1 When Using WSFC for Cluster Operation".
OPTIONS
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.
Specifies a connection instance. Specify an instance name in the operand. If this option is not specified, connection is made to the default instance.
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 is automatically selected. Specify a device map file name by using an absolute pathname.
Specifies performing the synchronous high-speed backup using the "Chapter 5 Backup Operation Using Suspend/Resume Function".
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 box when the ETERNUS Disk storage system supports 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
Specifies database names. If the database name contains a space, enclose it with double quotes.
When specifying two or more database names, separate the names with a space or tab as a delimiter. No more than 64 database names can be specified.
EXIT STATUS
=0: Completed successfully
>0: Terminated abnormally
EXAMPLES
Backup the databases DB01, DB02, and DB03 of virtual server VSERVER. (Assume that the logical node name of AdvancedCopy Manager is nodeAGT.):
C:\>set SWSTGNODE=nodeAGT C:\>C:\Win32App\AdvancedCopyManager\bin\swstbackup_sqlsvr -Xserver VSERVER DB01 DB02 DB03 DB01 DB02 DB03 swstbackup_sqlsvr completed C:\>
Backup the databases (DB01, DB02 and DB03) specifying the destination backup volumes by the device map file (G:\STGADM\devmap.txt):
C:\>set SWSTGNODE=nodeAGT C:\>C:\Win32App\AdvancedCopyManager\bin\swstbackup_sqlsvr -Xserver VSERVER -Xdevmap G:\STGADM\DEV.map DB01 DB02 DB03 DB01 DB02 DB03 swstbackup_sqlsvr completed C:\>
NOTES
You cannot perform backup in the following cases:
A specified database does not exist (This includes the case where neither the virtual server nor the instance exist).
In the case that two or more databases are specified, not all of the specified databases are databases of the same instance (In the case where -Xinstance option is not used, the processing is done to the default instance. In the case where -Xinstance option is used, the processing is done to the specified named instance).
A volume where the specified database is placed is not registered as a transaction volume.
Backup policy is not set for a database volume to be backed up.
A backup that was executed one generation earlier was unsuccessful.
Restore is being performed using backup history information that causes a generation overflow.
No unused backup volume could be found for use as the copy destination.
A drive letter has been assigned to a backup volume to be used as the copy destination.
The synchronous processing between the database volumes and the backup volumes is not in equivalency maintenance state.
After operation has begun, any of physical information (i.e., the box identifier, OLU number, EXTENT start position, or EXTENT size) of a volume has been changed.
65 or more databases have been specified.
A backup volume could not be locked
The backup volume locking specification file for backups is invalid
You cannot specify a destination backup volume and perform backup if:
The backup volume specified in a device map file cannot be used as the destination backup volume for a corresponding database volume. In other words, not all the following conditions are met:
The specified backup volume is unused.
The database volume and the backup volume have the same partition size.
The description on a target database volume of the device map file has an error.
If this command is executed during the execution of snapshot processing, stop the copy processing that is in progress and start the snapshot processing again.
This command backup two or more databases at the same time by specifying the operand. When, for example, two or more databases exist on one partition, or physical files of multiple databases exist together on volumes, perform the backup of all the databases which exist on the volumes by using this function.
This command freezes all the databases specified in operand by SQL Server until backup processing is completed. Thus, if the volumes where database files exist are independent in each database, back up each database two or more times to shorten the time they remain frozen as much as possible.
Because the process of securing data consistency for database volumes when the backup is performed is done by SQL Server, the pre-processing and post-processing (i.e., volume lock and unlock) are not executed, as they would be with a typical file system volume.
If an error occurs while this command is processing a database consisting of two or more volumes with this command, processing is interrupted. When you perform synchronous type backup, restart the stopped synchronous processing by using the swststartsync command.
If an error occurs while swstbackup_sqlsvr (SQL Server backup execution command) is processing the database consisting of two or more volumes with the swstbackup command, the backup history information on AdvancedCopy Manager may become inconsistent. In order to recover from such an inconsistent state, delete unnecessary history information using the swsthistdel command.
Figure 14.1 Recovery from History Information Inconsistency
Normally, if the existing backup history reaches the maximum number of saved generations specified by the swstbkpolset command, then information on the oldest generation is automatically deleted from the backup history information during the backup process, and the backup volume is cleared. However, if -suspend is specified for the backup history information, then the backup volume with the Suspend state is not cleared and the backup volume remains in use.
The transaction volume on which the backup command is executed, one other transaction volume, and the suspended backup volume cannot be specified as backup destinations in the device map file.
Before replication is performed in snapshot-type replication, this command option prevents other processes from accessing the replication destination volume in order to protect the process that is accessing the volume. The command accomplishes this by locking or dismounting the replication destination volume. In cases where the replication destination volume cannot be locked or dismounted, such as those described below, the command terminates with an error:
The mount point has a directory for mounting another volume.
The volume contains a file that is being used. If the replication destination volume is being used by a server that is not the server where the command was entered, prevent the replication destination volume from being accessed by cancelling share settings or performing dismounting for the replication operation, using the Administrator's authority.
This command cannot be executed if any of the following commands are running:
This command terminates abnormally if it cannot turn the maintenance mode of the physical disk resource ON.
NAME
swstrestore_sqlsvr - restores of SQL Server database.
SYNOPSIS
<program-directory>\bin\swstrestore_sqlsvr [-Xserver serverName] [-Xinstance instanceName] [-Xnolog] -Xmeta metaFileName dbName
DESCRIPTION
This command restores a SQL Server database. Execute this command after restoring database files using the swstrestore command. This command recreates a database from restored database files. To perform recovery after this command has been executed, apply logs using Management Studio or Transact-SQL.
OPTIONS
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.
Specifies a connection instance. Specify an instance name in the operand. If this option is omitted, connection is made to the default instance.
Specifies restoring a DB to a backup point, without applying logs. If this option is omitted, the DB is restored to a backup point but cannot be used until logs are applied to it. Apply logs using Management Studio or Transact-SQL.
Specifies a metadata file name, using an absolute pathname. A metadata file is 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
Specifies a database name. If the database name contains a space, enclose it with double quotes.
EXIT STATUS
=0: Completed successfully
>0: Terminated abnormally
EXAMPLES
Restore a database (DB01) using its backup data. The file restore using swstrestore has been completed and a metadata file exists at D:\SQLSVR\DB01.swst-dmp:
C:\>set SWSTGNODE=nodeAGT C:\>C:\Win32\AdvancedCopyManager\bin\swstrestore_sqlsvr -Xserver VSERVER -Xmeta D:\SQLSVR\DB01.swst-dmp DB01 DB01 swstrestore_sqlsvr completed C:\>
NOTES
You cannot specify a target backup volume and perform backup if:
Neither the virtual server nor the instance exists
By choosing whether or not to apply logs, you can select one of the following two restore methods:
Restore to a backup point (i.e., only restoring backup data)
Restore to the latest point or a specific point (i.e., restoring backup data and then applying logs)
