SQL 2000 SP3a, Database backup model is FULL: A full backup happens every sunday, Differential backups happens 1 time a day AM. Transaction Log happens 1 time a day PM. The Transaction log is 13GB, the transaction backup log is 15GB, everytime I run the transaction log backukp, the trans log backup grows(It should) but the transaction log does not truncate????
‘here is the backup log script
BACKUP LOG [NCSCabling]
TO DISK = N’E:\SQL\MSSQL\BACKUP\NCSCabling_Trans.bak’
WITH NOINIT , NOUNLOAD , NAME = N’NCSCabling backup’, NOSKIP , STATS = 10, NOFORMAT
