cancel
Showing results for 
Search instead for 
Did you mean: 

Ms-Sql database backup and truncate

sudhakarkumar
Level 4

Hi Friends,

We have configured MS-Sql Policy by creating Instances for database backup and transaction log backup.

Currently the db Backup was running fine and aswell transaction log also, but the transaction logs are not truncating even I have selected the truncate logs after backup option. Due to this the drive size is Full.

how can I solve this issue how can i delte the transaction logs after backup to free up the space.

 

My NBU ver:7.7.1

os-windows 2012 r2 standard 

 

1 REPLY 1

Marianne
Level 6
Partner    VIP    Accredited Certified

Have a look at this discussion:

https://vox.veritas.com/t5/NetBackup/How-to-backup-SQL-transaction-logs/td-p/621404

Extract:

Log truncation happens within the log file, with the file size staying the same. To actually give the file system back this "empty space" within the log file, the DBA can manually or automatically perform a shrink operation.