Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published:
Product(s): NetBackup (8.2)
  1. Introducing NetBackup for SQL Server
    1.  
      Overview of NetBackup for SQL Server
    2.  
      Features of NetBackup for SQL Server
    3.  
      NetBackup for SQL Server terminology
  2. Installing NetBackup for SQL Server
    1.  
      Planning the installation of NetBackup for SQL Server
    2.  
      Verifying the operating system and platform compatibility
    3.  
      NetBackup server and client requirements
    4.  
      Requirements for using NetBackup for SQL Server in a NetBackup cluster
    5.  
      About the license for NetBackup for SQL Server
  3. Managing SQL Server objects for use with SQL Server Intelligent Policies
    1.  
      About the Applications utility
    2. About autodiscovery of SQL Server objects
      1.  
        Discovering instances on demand
      2.  
        Discovering advanced or basic availability groups on demand
      3.  
        Discovering read-scale availability groups
    3.  
      Using the Applications utility to view SQL Server objects
    4. About registering SQL Server instances and availability group replicas
      1.  
        About credentials used with SQL Server Intelligent Policy
      2.  
        Configuring the NetBackup services for SQL Server backups and restores
      3.  
        Configuring local security privileges for SQL Server
      4.  
        Registering a SQL Server instance or availability replica
      5. Registering instances or availability replicas with an instance group
        1.  
          Adding an instance or availability replica to an instance group
        2.  
          Validating instance group credentials
      6.  
        Registering instances or availability replicas automatically
      7.  
        Authorizing a DBA to register instances or availability replicas with the nbsqladm command
    5.  
      Deleting SQL Server objects from the Applications utility
    6.  
      Manually adding a SQL Server instance in the Applications utility
    7.  
      Deactivating or activating an instance
    8.  
      Cleaning up instances
  4. Configuring SQL Server backups with SQL Server Intelligent Policy
    1.  
      About SQL Server Intelligent Policies
    2.  
      Adding a new SQL Server Intelligent Policy
    3.  
      About policy attributes
    4.  
      About schedule properties
    5.  
      Schedule backup types for SQL Server Intelligent Policies
    6.  
      Adding instances to a policy
    7.  
      Adding databases to a policy
    8.  
      Adding filegroups or files to the backup selections list
    9.  
      Manually adding files or filegroups to the backup selections list
    10.  
      Adding instance groups to a backup policy
    11.  
      About tuning parameters for SQL Server backups
    12.  
      Backing up read-only filegroups
    13.  
      Backing up read-write filegroups
  5. Configuring NetBackup for SQL Server
    1.  
      Configuring mappings for restores of a distributed application, cluster, or virtual machine
    2.  
      Reviewing the auto-discovered mappings in Host Management
    3.  
      About NetBackup for SQL performance factors
    4.  
      Configuring the number of jobs allowed for backup operations
    5.  
      Configuring the Maximum jobs per client setting
    6.  
      Configuring multistriped backups of SQL Server
    7.  
      Performing a manual backup
  6. Performing restores of SQL Server
    1.  
      Starting the NetBackup MS SQL Client for the first time
    2.  
      Selecting the SQL Server host and instance
    3.  
      Browsing for SQL Server backup images
    4.  
      Options for NetBackup for SQL Server restores
    5.  
      Restoring a SQL Server database backup
    6.  
      Staging a full SQL Server database recovery
    7.  
      Restoring SQL Server filegroup backups
    8.  
      Recovering a SQL Server database from read-write filegroup backups
    9.  
      Restoring SQL Server read-only filegroups
    10.  
      Restoring SQL Server database files
    11.  
      Restoring a SQL Server transaction log image without staging a full recovery
    12.  
      Performing a SQL Server database move
    13.  
      About performing a SQL Server page-level restore
    14.  
      Configuring permissions for redirected restores
    15. Redirecting a SQL Server database to a different host
      1.  
        About selecting a master server
    16.  
      Performing a restore of a remote SQL Server installation
    17.  
      About restores of a database that contain full-text catalog
    18. Restoring multistreamed SQL Server backups
      1.  
        About conventional backups using multiple streams
      2.  
        About snapshot backup methods using multiple streams
      3.  
        Restoring a multistreamed SQL Server backup with fewer devices than it was backed up with
    19.  
      About using bplist to retrieve SQL Server backups
    20.  
      About NetBackup for SQL Server backup names
  7. Protecting SQL Server data with VMware backups
    1. About protecting SQL Server data with VMware backups
      1.  
        About the Veritas VSS provider for vSphere
      2.  
        Limitations of using a VMware policy to protect SQL Server
    2.  
      About configuring NetBackup for VMware backups that protect SQL Server
    3.  
      Using NetBackup Accelerator to increase speed of full VMware backups
    4.  
      Installing the Veritas VSS provider for vSphere
    5.  
      Configuring the NetBackup services for VMware backups that protect SQL Server
    6.  
      Configuring a VMware backup policy to protect SQL Server
    7.  
      Configuring a VMware policy to protect SQL Server using Replication Director to manage snapshot replication
    8.  
      About truncating logs with a VMware backup that protects SQL Server
    9.  
      Restoring SQL Server databases from a VMware backup
  8. Using NetBackup for SQL Server with Snapshot Client
    1.  
      About NetBackup Snapshot Client for SQL Server
    2.  
      How SQL Server operations use Snapshot Client
    3.  
      Configuration requirements for SQL Server snapshot and Instant Recovery backups
    4.  
      Configuring a snapshot policy for SQL Server
    5.  
      Configuring a policy for Instant Recovery backups of SQL Server
    6. Using copy-only snapshot backups to affect how differentials are based
      1.  
        Sample backup schedule using copy-only backups
      2.  
        Creating a copy-only backup (legacy SQL Server policies)
      3.  
        Creating an Instant Recovery backup that is not copy-only (legacy SQL Server policies)
    7. About SQL Server agent grouped backups (legacy SQL Server policies)
      1.  
        Requirements for a grouped backup
      2.  
        Viewing the progress of a grouped backup
      3.  
        Restoring a database backed up in a group
  9. Protecting SQL Server availability groups
    1.  
      About using NetBackup to protect SQL Server availability groups
    2. Protecting SQL Server availability groups with intelligent policies
      1.  
        About protecting the preferred or primary replica in a SQL Server availability group
      2.  
        Prerequisites for protecting SQL Server availability groups
      3. Configuring a backup policy to protect a SQL Server availability group
        1.  
          Adding an availability group to a policy
        2.  
          Adding availability databases to a policy
        3.  
          Adding filegroups or files in an availability database to the backup selections list
    3. Protecting SQL Server availibility groups with legacy policies
      1. About protecting the preferred replica in a SQL Server availability group (legacy backup policies)
        1.  
          Prerequisites for protecting SQL Server availability groups
        2.  
          Configuring an automatic backup policy for the preferred or the primary replica of a SQL Server availability group
        3.  
          Creating batch files for the policy that protects the preferred or the primary replica
        4.  
          Adding the batch files to the policy that protects the preferred or the primary replica
      2. About protecting a specific node in a SQL Server availability group (legacy backup policies)
        1.  
          Configuring an automatic backup policy for a specific replica of a SQL Server availability group
        2.  
          Creating a batch file for the policy that protects a specific availability replica in an availability group
        3.  
          Adding the batch files to the policy that protects a specific replica in the availability group
    4.  
      Configuring SQL Server backups when an availability group crosses NetBackup domains
    5.  
      Browsing for SQL Server availability group backup images
    6.  
      Restoring a SQL Server availability database to a secondary replica
    7.  
      Restoring a SQL Server availability database to the primary and the secondary replicas
    8.  
      Restoring an availability database when an availability group crosses NetBackup domains
  10. Protecting SQL Server in a cluster environment
    1.  
      Configuring backups of clustered SQL Server instances (SQL Server Intelligent Policy)
    2.  
      Configuring backups of clustered SQL Server instances (legacy SQL Server policies)
    3.  
      Performing a restore of a virtual SQL Server instance
  11. Configuring backups with legacy SQL Server policies using clients and batch files
    1.  
      About legacy SQL Server policies
    2.  
      About configuring backups with legacy SQL Server policies
    3.  
      Configuring the NetBackup services for SQL Server backups and restores (legacy SQL Server policies)
    4.  
      About SQL Server security with NetBackup legacy backup policies
    5. About using batch files with NetBackup for SQL Server
      1.  
        Keywords and values used in batch files
      2.  
        Creating a batch file
      3.  
        Running batch files
    6.  
      Adding a new SQL Server legacy policy
    7. About schedule properties
      1.  
        Legacy policy backup types
      2.  
        Converting differential backups to full backups
      3.  
        Configuring an application backup schedule
      4.  
        Example application backup schedule
      5.  
        Configuring automatic backup schedules
      6.  
        Example automatic backup schedule
    8.  
      Adding clients to a policy
    9.  
      Adding batch files to the backup selections list
    10.  
      Selecting the SQL Server host and instance
    11.  
      Options for SQL Server backup operations
    12.  
      About viewing the properties of the objects selected for backup
    13. Performing user-directed backups of SQL Server databases
      1.  
        Performing user-directed backups of SQL Server transaction logs
      2.  
        Performing user-directed backups of SQL Server database filegroups
      3. Performing user-directed backups of read-only filegroups
        1.  
          Viewing SQL Server read-only backup sets
      4.  
        Performing user-directed backups of read-write filegroups
      5.  
        Performing user-directed backups of SQL Server database files
      6.  
        Performing partial database backups
    14.  
      Performing a backup of a remote SQL Server installation
    15.  
      About file checkpointing with NetBackup for SQL Server
    16.  
      About automatic retry of unsuccessful SQL Server backups
  12. Using NetBackup for SQL Server with multiple NICs
    1.  
      About configuration of SQL Server backups with multiple NICs
    2.  
      Configuring the NetBackup client with the private interface name
    3.  
      Configuring backups of SQL Server when you have multiple NICs (SQL Server Intelligent Policies)
    4.  
      Configuring backups for SQL Server when you have multiple NICs (legacy SQL Server policies)
    5.  
      Performing restores of SQL Server when you have multiple NICs
    6.  
      Configuring backups of a SQL Server cluster when you have multiple NICs (SQL Server Intelligent Policies)
    7.  
      Configuring backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies)
    8.  
      Creating a batch file for backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies)
    9.  
      Performing restores of a SQL Server cluster when you have multiple NICs
  13. Protecting SQL Server a log-shipping configuration
    1.  
      Configuring NetBackup to support database log-shipping
    2.  
      Backing up SQL Server in an environment with log shipping
  14. SQL Server backups and restores in an SAP environment (legacy SQL Server policies)
    1. About SQL Server backups and restores in an SAP environment
      1. Creating batch files for automatic backups in for SQL Server in an SAP environment
        1.  
          Creating a batch file for database backups
        2.  
          Creating a batch file for transaction log backups
      2.  
        Monitoring backups on SQL Server
      3. Restoring the R/3 database
        1.  
          About including differential backups in a restore operation
        2.  
          Restoring the R/3 database after a disk crash
        3.  
          Restoring the database backups and transaction log backups
    2.  
      About manual backups of SQL Server in an SAP environment
    3.  
      About policy configuration for SQL Server in an SAP environment
  15. Backup and recovery concepts
    1. Overview of SQL Server backup and recovery concepts
      1.  
        About SQL Server system database types
      2.  
        About SQL Server database backups
      3.  
        About SQL Server filegroup backups
      4.  
        About SQL Server differential backups
    2.  
      What are the components of NetBackup for SQL Server?
    3.  
      How does NetBackup resolve SQL Server host and instance names?
    4.  
      How does NetBackup for SQL Server back up a database?
    5.  
      How does NetBackup for SQL Server recover a database?
    6.  
      Protecting SQL Server files and filegroups
    7.  
      About recovery considerations for SQL Server files and filegroups
    8.  
      Reducing backup size and time by using read-only filegroups
    9.  
      What factors affect the data transfer rate during a SQL Server backup or restore operation?
    10. About recovery factors for SQL Server
      1.  
        About SQL Server transaction logs
      2.  
        About recovery strategies
      3.  
        About backing up the transaction log
      4.  
        About differential backups
      5.  
        About file and filegroup backups
      6.  
        About database recovery
      7.  
        About staging recovery
  16. Troubleshooting
    1.  
      About monitoring NetBackup for SQL Server operations
    2.  
      About NetBackup reports for SQL Server troubleshooting
    3. About debug logging for SQL Server troubleshooting
      1.  
        Creating all NetBackup debug logs for SQL Server troubleshooting
      2.  
        About backup operation debug logging for SQL Server
      3.  
        About restore operation debug logging for SQL Server
      4.  
        Setting the debug level
      5.  
        Veritas VSS provider logs
    4.  
      Setting the maximum trace level for NetBackup for SQL Server
    5.  
      Troubleshooting credential validation in the Applications utility
    6.  
      About minimizing timeout failures on large SQL Server database restores
    7.  
      Troubleshooting VMware backups and restores of SQL Server
    8.  
      Delays in completion of backup jobs
    9.  
      SQL Server log truncation failure during VMware backups of SQL Server
    10.  
      SQL Server restore fails when you restore a SQL Server compressed backup image as a single stripe or with multiple stripes
    11.  
      Incorrect backup images are displayed for availability group clusters
    12.  
      A restore of a SQL Server database fails with Status Code 5, or Error (-1), when the host name of the SQL Server or the SQL Server database name has trailing spaces
    13.  
      A move operation fails with Status Code 5, or Error (-1), when the SQL Server host name, the database name, or the database logical name has trailing spaces
  17. Disaster recovery of a SQL Server
    1.  
      About disaster recovery of SQL Server
    2.  
      Preparing for disaster recovery of SQL Server
    3.  
      Recovering SQL Server databases after disaster recovery
  18. Appendix A. Sample batch files
    1. About sample backup batch files for legacy SQL Server policies
      1.  
        Script to back up a database
      2.  
        Script to perform a striped database backup and allow multiple internal buffers per stripe
      3.  
        Script to perform an operation and specify the user ID and password to use to SQL Server
      4.  
        Script to perform multiple operations in sequence
      5.  
        Script to perform a set of operations in parallel
      6.  
        Script to specify the maximum transfer size and block size for a backup
      7.  
        Script that uses environment variables to exclude instances and databases from backup
    2. About sample restore batch files
      1.  
        Script to restore a database
      2.  
        Script to restore a database from multiple stripes
      3.  
        Script to stage a database restore from a filegroup backup, several file backups, and transaction log backups
      4.  
        Script to restore a database transaction log up to a point in time
      5.  
        Script to stage a database restore from a database backup, a differential backup, and a series of transaction backups
  19. Appendix B. Multiplexed backups
    1.  
      Configuring multiplexed backups of SQL Server
    2.  
      Restoring a multiplexed SQL Server backup
  20. Appendix C. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

Keywords and values used in batch files

Table: Keywords and values used in batch files describes the keywords and values that can be used in batch files.

Table: Keywords and values used in batch files

Keyword

Values

Required?

Default

Description

ALTCLIENT (Same as BROWSECLIENT)

string

no

none

Restores the images from a host other than the local host.

BACKUPMODEL

BACKUPMODEL_
CONVENTIONAL, 
BACKUPMODEL_ SNAPSHOT

no

BACKUPMODEL_CONVENTIONAL

Valid only for restore. Indicates whether the backup was originated from a snapshot method

BATCHSIZE

integer

no

1

Number of backup operations to start simultaneously, per database instance. Applies to all of the operations in the batch file. Must appear before the end of the first operation. Range is 1 - 32.

BLOCKSIZE

integer

no

0

Applicable for backup operations only. Block size is calculated as 512 bytes * 2BLOCKSIZE. Range is 0 - 7.

BROWSECLIENT (Same as ALTCLIENT)

string

no

none

Restores the images from a host other than the local host.

BUFFERS

See NUMBUFS.

CONSISTENCYCHECK

FULLINCLUDINGINDICES, FULLEXCLUDINGINDICES, PHYSICALCHECKONLY, CHECKCATALOG

no

none

Performs the specified consistency check after the restore has been completed.

CONVERTBACKUP

TRUE, FALSE

no

FALSE

If no previous full backup exists for the database or filegroup, then NetBackup converts the differential or log backup to a full backup.

This option also detects if a full recovery database was switched to the simple recovery model and back to the full recovery model. In this scenario, the log chain is broken and SQL Server requires a differential backup before a subsequent log backup can be created. If NetBackup detects this situation, the backup is converted to a differential database backup.

See Converting differential backups to full backups.

COPYONLY

TRUE, FALSE

no

See description

If TRUE, SQL Server creates an out-of-band backup so that it does not interfere with the normal backup sequence. The default value is FALSE except for full database Instant Recovery backups.

DATABASE

string

yes

none

Name of database. For backup operations, specify value $ALL to designate all databases (except for tempdb.)

DBMS

MSSQL

no

MSSQL

You can specify MSSQL only.

DSN

string

no

saved from GUI user session

ODBC data source name. Deprecated.

DUMPOPTION

INCREMENTAL

no

none

Specifies INCREMENTAL restoring from an incremental backup.

ENABLESERVICEBROKER

TRUE

no

none

Enables SQL Server Service Broker after a restore operation. To take effect, RECOVERED STATE must be set to RECOVERED. Include this keyword in each individual RESTORE operation.

ENDOPER

TRUE

yes

none

Terminates each operation that is specified in the batch file.

EXCLUDE

string

no

none

Name of a database to exclude when DATABASE $ALL is specified in a batch operation

EXCLUDE can be used in a batch file only if DATABASE $ALL is used.

GROUPSIZE

integer between 1 and 32

no

none

The number of databases that are snapped as a single SQL Server backup image.

(Legacy policies) For availability group backups, all databases in the grouped backup must be part of the availability group. NetBackup does not support any grouped snapshot backups that include both standard and availability databases.

(Intelligent Policies) NetBackup does not support grouped snapshot backups.

INHIBITALTBUFFER METHOD

TRUE, FALSE

no

FALSE

Tells NetBackup whether to consider the candidacy of alternate buffer method.

MAXRESTARTSETS

integer

no

none

Use MAXRESTARTSETS to enable file checkpointing. This parameter specifies the number of separate streams into which the backup request is sub-divided. Range is 2 - 32.

MAXTRANSFERSIZE

integer

no

0

Maximum transfer size is calculated as 64 kilobytes bytes * 2MAXTRANSFERSIZE. Range is 0 - 6.

MOVE

filegroup

no

none

Specifies a filegroup name. Used for the MOVE restore type. For any backups that were made with a SQL Server legacy policy, the PARTIAL restore type also applies.

NBIMAGE

string

yes*

none

Specifies a NetBackup image for the restore operations. See note for NBSERVER.

* Required for restore operations.

NBSCHED

string

no

none

If the NetBackup policy has several Application Backup Policy schedules, use NBSCHED to select amongst them.

NBSERVER

string

no

none

Specifies which master server to use for the backup or restore operation.

Note:

If NBSERVER is not specified in a batch file operation, the master server defaults to the name that is specified at HKEY_CURRENT_USER\Software\VERITAS\NetBackup\NetBackup for Microsoft SQL Server\DEFAULT_SQL_NB_MASTER_SERVER.

NUMBUFS

integer

no

1

Number of buffers per stripe. Range is 1 - 32.

NUMRETRIES

See NUMRESTARTS.

NUMRESTARTS

1-9

no

1

The number of times to retry a backup if RESTARTTYPE AUTO is specified. Use this keyword only once in the batch file and in the first operation of the batch file.

OBJECTNAME

string

yes*

none

Specifies a file or a filegroup name for file or for filegroup backups and restores,

* If OBJECTTYPE= FILE or FILEGROUP.

OBJECTTYPE

DATABASE, TRXLOG, FILEGROUP, FILE

no

DATABASE

Specifies the object you want to back up or restore, a database, transaction log, filegroup, or file.

OPERATION

BACKUP, RESTORE

no

BACKUP

Type of operation, either backup or restore.

PAGE

Page ID

no

none

Ignored for a restore if the backup was performed with SQL Server Intelligent Policy.

Specifies a page ID for a page restore operation.

PARTIAL

TRUE, FALSE

no

FALSE

Ignored for a restore if the backup was performed with SQL Server Intelligent Policy.

Specifies NetBackup perform a partial backup or restore.

PASSWORD

string

no

null

Password for logging into SQL Server. This keyword is ignored if you use integrated security.

PREFERREDREPLICA

NONE, PRIMARY, PREFERRED,SKIP, TRUE, FALSE

no

PRIMARY

For each operation in the batch file, include this keyword.

(All NetBackup versions) TRUE honors your SQL Server backup preferences. FALSE indicates there is no preference for the replica that is used for backup.

(NetBackup 8.2 and later clients)

NONE means the backup is performed on the specified instance. Use SKIP to ignore any availability databases on the instance. Use this value to protect only standard databases when the policy includes any instances that contain both standalone databases and availability databases.

PRIMARY and PREFERRED apply to availability replicas and to instances that have both standard and availability databases. PRIMARY means that the primary replica is used for backup. PREFERRED honors your SQL Server backup preferences. These preferences include the preferred replica, backup priority, and excluded replicas. Note that NetBackup initiates a backup job on each replica. The backup is skipped on any replica that isn't the intended backup source.

RECOVERED STATE

RECOVERED, STANDBY, NOTRECOVERED, TRUE, FALSE

no

RECOVERED

RECOVERED means that the database should be restored to the recovered state. NOTRECOVERED means that it should remain in the loading state following the restore. STANDBY means that the database should be restored to standby state. If STANDBY is used, then the STANDBYPATH keyword is also required. TRUE and FALSE, when used as values for RECOVEREDSTATE, are synonyms for RECOVERED and NOTRECOVERED.

RESTARTTYPE

AUTO, MANUAL

no

none

Available only for backups. Use AUTO to automatically retry backup of failed objects. Use MANUAL to create a batch file for backing up any of the objects that were not successfully backed up. Use this keyword only once in the batch file and in the first operation of the batch file.

RESTARTWAITSECONDS

integer number

no

60

The time to make a second attempt following a backup failure. Use this keyword only once in the batch file and in the first operation of the batch file.

RESTOREBEFOREMARK

string

no

none

Specify transaction log mark.

RESTOREBEFOREMARK AFTERTIME

string

no

none

Specify transaction log mark.

RESTOREOPTION

REPLACE

no

none

Tells NetBackup to use the SQL Server replace option on a restore.

RESTOREPAGES

TRUE, FALSE

no

FALSE

Ignored for a restore if the backup was performed with SQL Server Intelligent Policy.

Specifies that NetBackup perform a page restore operation.

RESTORETOMARK

string

no

none

Specify transaction log mark.

RESTORETOMARK AFTERTIME

string

no

none

Specify transaction log mark.

RESTORETYPE

FULL, PARTIAL, MOVE

no

FULL

Full = Full database restore, Move = Database move

RESTORETYPE is applicable only to RESTORE database operations. If MOVE is used, then the batch file should contain a series of one or more <MOVE><filegroup> and <TO><file path> sequences.

(SQL Server legacy policies only) Partial = Partial database restore.

If PARTIAL is used, the sequence for PARTIAL must specify all of the filegroups in the database whose backup image is referenced by the NBIMAGE keyword.

RETRYTYPE

   

See RESTARTTYPE.

RETRYWAITSECONDS

See RESTARTWAITSECONDS.

ROLLBACKVOLUME

TRUE, FALSE

no

FALSE

Tells NetBackup to do the recovery of an Instant Recovery backup using the volume rollback method.

SQLCOMPRESSION

TRUE, FALSE

no

FALSE

Uses SQL Server compression on the backup image. If you enable SQL Server compression, do not enable NetBackup compression.

SQLHOST

string

no

Name of SQL Server host.

If SQLHOST is not specified in a batch file operation, then the SQL Server host is obtained from HKEY_CURRENT_USER\Software\VERITAS\NetBackup\NetBackup for Microsoft SQL Server\DEFAULT_SQL_HOST. If the SQLINSTANCE keyword is not included, then the default SQL Server instance is assumed for the SQL Host.

SQLINSTANCE

string

no

Name of the SQL Server instance. Or for backup operations specify $ALL to designate all SQL Server instances including the default instance.

If SQLINSTANCE $ALL is used, then it must appear in the first operation of the batch file. Each operation in the batch file is performed for all SQL Server instances on the client where the batch file is executed. Also, it is not necessary to specify an SQLHOST or SQLINSTANCE on any subsequent operations.

STANDBYPATH

string

no

none

Specify a fully- qualified file path to use for the standby redo log.

STOPAFTER

datetime string

no

none

Specifies datetime for RESTORETOMARK options. The datetime string is formatted as YYYY/MMDDHH:MM:SS.

STOPAT

datetime string

no

none

Specifies the point-in-time recovery of a transaction log. The datetime string is formatted as YYYY/MMDDHH:MM:SS.

STORAGEIMAGE

string

no

none

Used for restoring a database that was backed up using a grouped Snapshot Client snapshot. STORAGEIMAGE identifies the image with which the physical files are associated.

STRIPES

integer

no

1

Number of stripes. Range is 1 - 32.

TO

file path

no

none

Specifies a filegroup destination path. Required for each MOVE keyword. Also must sequentially follow each MOVE entry. The value may be delimited with single quotes.

TRACELEVEL

MIN, MID, MAX

no

MIN

Trace level.

TRXOPTION

NOTRUNC, TAILLOG

no

none

SQL Server transaction log backup options.

If NOTRUNC is not selected, then the transaction log can be backed up and truncated. If TAILLOG is selected, the tail log is backed up and restored.

USERID

string

no

sa

User ID for logging into SQL Server. This keyword is ignored if you use integrated security.

VDITIMEOUTSECONDS

integer

no

300

Timeout interval for SQL Server Virtual Device Interface.

VERIFYONLY

TRUE, FALSE

no

FALSE

Tells SQL Server to verify a backup image but not to restore it.

VERIFYOPTION

NONE, STOPONERROR CONTINUEAFTERERROR

no

NONE

This option is only valid for the databases that have an active page. STOPONERROR performs verification and stops if a verification error occurs. CONTINUEAFTERERROR performs verification but continues if a verification error occurs.