Posted on 2008-11-01
I am doing FULL backups at 12:00 AM every night with the below script. From 6:00 AM until 10:59:59 PM everyday I am running the lower most script every fifteen minutes. Problems is that the database .ldf is growing and growing. How do I trim it down prior/or during the Full backup?
BACKUP DATABASE [AdminDB] TO DISK = N'\\clwfile03\system_backups$\CLWSQLPD01\AdminDB_FULL.Bak' WITH NOFORMAT, INIT, NAME = N'AdminDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
BACKUP LOG [AdminDB] TO DISK = N'\\clwfile03\system_backups$\CLWSQLPD01\AdminDB_Log.Trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT,
NAME = N'Pods-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10