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 |
|
isitme
Starting Member
3 Posts |
 Posted - 2008-11-25 : 04:56:48
|
| I had an issue yesterday whereby our SQL Servers' Transaction Log drive ran out of disk space. The space ran out because the Transaction log backups had not been deleted as per database maintenance plan which states that files are removed that are older than 1 week. It seems to have not deleted the Tlog backups for over 4 weeks although the corresponnding database backups are deleted as normal.I made a slight change to the DM plan and saved it before reverting back in the hope that a resave of the DB plan would get the Tlog backups removed as per setting but this has not worked.Is there any way of resolving this other than manually deleting the files? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-25 : 09:54:37
|
| It should have been deleted if you have chosen to delete.Did you check jobs history? Any Message? |
 |
|
|
isitme
Starting Member
3 Posts |
Posted - 2008-11-25 : 10:49:46
|
| Hi Sodeep - I checked the history first. The history only goes back a week but there are no 'Delete old tlog backup files' in the activity column. There are corresponding 'Delete old db backup files' though which makes it so perplexing.We have another maintenance plan that is configured especially for one database and this has no problem with deleting the tlog backup files older than a week. |
|
|
|
isitme
Starting Member
3 Posts |
Posted - 2008-11-27 : 11:17:22
|
| Now resolved and quite a simple resolution in the end.I also found I wasn't interogating the maintenance plan history enough otherwise I would have seen the tlog failures earlier!I remembered that we recently added a new database which was set to Simple recovery model. I added this db to an existing Database Maintenance Plan that included a transaction log backup.It obviously failed when it tried to backup the tlog for this database and subsequently did not continue with deleting the tlog backups as per retention period set in the plan.I have created a new db maintenance plan specifically for this db that excludes a tlog backup. The original maintenance plan is now happilly deleting the tlog backups as normal. |
|
|
|
|
|
|
Database Maintenance Plan issue