NetBackup for SQL Server terminology
Table: NetBackup for SQL Server terminology shows the important terms that might be new to a SQL Server database administrator or a NetBackup administrator.
Table: NetBackup for SQL Server terminology
Term | Definition |
|---|---|
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 for each stripe that is specified. |
multiplex | When more than one backup stripe is written simultaneously to the same tape. |
multistream | 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. |