I am having some issues with the LDF file truncating on a SQL backup.
We have a nightly job that is backing up 3 SQL 2005 SP1 servers. 2 of the server are standalone SQL boxes while the third is a 2-node cluster.
The backups of the standalone boxes go just fine, but the cluster is having some issues. Specifically, each night the LDF files on the standalone boxes are truncated. But the LDF file on the cluster does not truncate.
Is there something special I need to do to get the LDF to truncate on the cluster? All servers have the SQL agent installed and the backups are successful, but the LDF on the cluster will not truncate each night.
Please let me know what I need to do to get the LDF to truncate each night
Message Edited by Drew Henning on 04-26-200708:03 AM