Netbackup and Truncating logs on Microsoft SQL Server

[kimihira]

Hi,

Can someone at Symantec please confirm that the following is true:  When Netbackup performs a backup of Microsoft SQL Server with the truncate logs option enabled; it will only clear out the contents of the log files and not reduce their size?

If this is the case, is there a Netbackup feature to both truncate and reduce the actual size of the log file on disk?

David

[Marianne · Accepted solution]

The DBA will have to shrink the logs.

See these similar discussions:

https://www-secure.symantec.com/connect/forums/netbackup-mssql-not-truncating-log

https://www-secure.symantec.com/connect/forums/how-backup-sql-transaction-logs

[Mark_Solutions]

As Marianne says it doesnt shrink the log file - that is a SQL function

Here is quite a nice tech note covering it and the options:http://technet.microsoft.com/en-us/library/ms178037(v=sql.105).aspx

But apparently it is best to leave them as they are for improved performance - after all they will only grow to that size again if normal transactions take place regularly