NetBackup for SQL Server terms
The table describes the important terms that might be new to a SQL Server database administrator or a NetBackup administrator.
Table: NetBackup for SQL Server terms
Term | Definition |
|---|---|
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.) |
Incremental 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 | Backs up the transactions that have occurred since the last transaction log backup. After a successful backup, the log is cleared so that new transactions can be written to the file. A transaction log backup can only be performed against a database that is configured to run in the full recovery model. |
Restore | To copy data back to a SQL Server object. |
Recovery | To bring a database online as a result of a restore. |
SQL Server 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 Server instance | A SQL Server installation. If an instance is not specified, it is considered the default SQL instance for the SQL host. |