Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sundaresan
Starting Member
28 Posts |
 Posted - 2007-12-28 : 05:08:53
|
| We have a maintainance plan for all the databases. It does all the completed backup and Transaction Log backup.we have instructed the maintainance plan to remove files older than 3 days for both completed backups and Transaction log backups.But Files older than 3 days is getting removed in complete backup where as it is not the case in transaction log back up.We have enough disk space also.Please helpSundaresan.R |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-28 : 23:58:29
|
| Take look at plan's log file to find out why it didn't delete old log backup files. |
 |
|
|
Sundaresan
Starting Member
28 Posts |
Posted - 2007-12-31 : 04:45:30
|
| Thanks rmaio. I checked the log and found that some databases were in simple recovery mode. I changed it to Full recovery mode. Now Transactional log backups in database maintainance plan works well.Sundaresan.R |
|
|
|
|
|
|
Transaction log backups not getting removed.