SQL Backups question

[BTLOMS]

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 ?

thanks,

[RiaanBadenhorst · Accepted solution]

Hello, Take a look at this note. http://www.symantec.com/docs/TECH42524 Trn backup will do it. Not a full.

[Walker_Yang1]

Hello, BTLOMS

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:

http://databases.about.com/od/sqlserver/a/recoverymodels.htm

http://www.mytechmantra.com/LearnSQLServer/SQL_Server_Recovery_Model.html

Thanks