How to find out whether the transaction logs are being truncated or not

[Former Member]

Hi,

We are using Veritas Backup tool for Backups and restores on our MS SQL 2000.

One of our Veritas Tech has disabled the Truncation of Transaction Log Backup using the Job setup in Veritas. We want to confirm whether the Truncation is happening or not. I don't see any difference in the Transaction Log file size.

How to find out whether truncation is active or not?

Thanks

Vijay

[Former Member]

Thanks for all your help.

[former_member185954]

glad to help

[former_member185954]

Hello Vijay,

On MSSQL truncation of transaction log does not shrink the size of the transaction log. It simply removes the content within the transaction log and writes it to the backup.

Meaning the free percentage within the transaction log will increase.

If you want to Resize the transaction log size, you need to do something else.

The shrinking procedure is given here:

http://support.microsoft.com/kb/907511

Regards,

Siddhesh