Video Screencast Help

SQL Backups question

Created: 12 Aug 2014 • Updated: 29 Oct 2014 | 2 comments
This issue has been solved. See solution.

When doing an SQL backup does the full backup also backup and truncate the transaction logs? Also, and incremental backup will only backup the tlogs right ?


Operating Systems:

Comments 2 CommentsJump to latest comment

Riaan.Badenhorst's picture


Take a look at this note.

Trn backup will do it. Not a full.


Riaan Badenhorst

ITs easy :)

Walker_Yang's picture


Except for the settings on netbackup, it's also related to MS SQL Server's recovery model.

There are 3 reovery models in MS SQL Server, Simple, Full, Bulk-logged.

For simple recovery model, it supports full or incremental DB backup, doesn't support transaction log backup, when full or incremental backup, it truncates transaction log automatically to release disk space, but don't backup transaction log.

For full recovery model, supports full or incremental DB backup, and transaction log backup, when full or incremental DB backup, don't truncate transaction log automatically, so need to backup transaction log alone to release disk space.

For Bulk-logged recovery model, additional model of full recovery model, will log minimal amount of information for operations, usually doesn't support point in time of recovery.

More info, could refer to the following link: