Question Locked

SQL 2005 Tran Logs not truncating

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here is the sql script for the db backup

BACKUP DATABASE [FCE] TO DISK = N'\\JUM1\GPBackups\FCE nightly backup' WITH INIT , NOUNLOAD , NAME = N'FCE nightly backup', NOSKIP , STATS = 10, DESCRIPTION = N'FCE nightly backup', NOFORMAT

The back up runs but the tran log backup just keeps getting bigger. The actual tran log file is not large.

If I do a manual backup in the database itself separate from the maintenance plan it truncates normally. What is wrong with the attached script?

Help! Why?

Joanne Mahoney

1 reply

This discussion is closed to new replies.