batch file

The script that is used to back up or to restore SQL Server objects. The database agent performs all operations through a batch file. Batch files are typically stored in the install_path\dbext\mssql\ directory. For operations executed immediately from the NetBackup Microsoft SQL Client, a temporary batch file is placed in the following directory:

\Veritas\Netbackup\dbext\mssql\temp directory

full backup

A complete backup of the database that contains all of the data files and the log file. (Note that a full backup does not truncate the transaction log.)

differential backup

A backup of the changed blocks since the last full backup.

transaction log

An ongoing record of updates that were made to a database.

transaction log backup

A backup of the inactive portion of the transaction log. Typically, this portion of the transaction log is truncated after it has been backed up successfully.

restore

To copy data back to a SQL Server object (see "recovery").

recovery

To bring a database online as a result of a restore.

SQL host

The host machine on which SQL Server resides. It may also refer to the virtual name of a cluster that supports a SQL Server installation.

SQL instance

A SQL Server installation. If an instance is not specified, it is considered the default SQL instance for the SQL host.

source client

A NetBackup term that identifies a host machine. The source client is commonly the network name of the host. It can also be an IP address or a cluster name, depending on how it is identified in the client configuration.

backup stripes

A data stream that is used for a backup or a restore of SQL Server objects. The user specifies the number of stripes for the backup. NetBackup performs a separate job each stripe that is specified.

multiplex

When more than one backup stripe is written simultaneously to the same tape.

multistream

multistreaming is the generic method in which NetBackup manages a backup or restore that includes multiple backup stripes. Multiplexing is an example of multistreaming. NetBackup can also perform a multistreamed backup by writing individual streams to individual drives.

ODBC

An open interface protocol that NetBackup for SQL Server uses to interact with SQL Server.

VDI

Virtual device interface. A proprietary interface that SQL Server provides for backup and for restore. The interface is used both for snapshot and for streamed operations. A VDI connection is managed as a COM object.