Video Screencast Help

SQL Backups question

Created: 12 Aug 2014 | 2 comments

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,

Operating Systems:

Comments 2 CommentsJump to latest comment

Riaan.Badenhorst's picture

Hello,

Take a look at this note.

http://www.symantec.com/docs/TECH42524

Trn backup will do it. Not a full.

Regards,

Riaan Badenhorst

You need an OpenVision to see the truth about Backups. Restores are a plus. But that's just Semantics ;)

ITs easy :)

Walker_Yang's picture

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