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.
|