Full database backup TDP for SQL backs up an entire SQL server database and the portion of the transaction log necessary to provide a consistent database state. With both full and differential backups, the copy includes enough information from any associated transaction logs to make a backup consistent with itself. The portion of the log included contains only the transactions that occur from the beginning of the backup until its completion.
Note: You do not have to do a full backup to constitute the equivalent of a full backup. Backing up all the groups or files in a database as well as its log are recognized as a full backup by SQL. A base backup may be a full, group, file, or set.
Differential backup TDP for SQL backs up only the data pages in a SQL server database changed since the last full backup and a portion of the transaction log.
Log backup TDP for SQL backs up only the contents of a SQL server database transaction log since the last successful log backup. To do the first log backup, you need to have done a full backup or its equivalent first. Log backups normally follow full backups. The portion of the log included in full and differential backups is not equivalent to a log backup. Additionally, in full and diff backups, the log is not truncated as it is during a log backup. However, a log backup following a full or differential backup will include the same transactions as a full or differential. Log backups are not cumulative as are differential; they must be applied against a base backup and in the correct order.
Note: A log backup in SQL terms is not equivalent to an incremental backup in TSM terms.
File backup TDP for SQL backs up only the contents of a specified SQL server logical file. This can ease the scheduling for backing up very large databases by allowing you to back up different sets of files during different scheduled backups. File, group, and set backups must be followed by a log backup, but a full is not required.
Group backup TDP for SQL backs up only the contents of a specified SQL server filegroup. This allows you to back up just the set of database tables and indexes within a specific group of files.
Set backup TDP for SQL backs up the contents of specified SQL server filegroups and files as a unit.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!