Hello folks,
Not a question, but a quick note for those who get stuck with SQL Server admin stuff for handling their access backends (and don't do this all the time)...
I noticed that after I set up database maintenance plans on both my Sql Server 2005 and 2008 that the "maintenance cleanup task" wasn't removing my old .trn and .bak files even though the job shows success in the history... so they will taking up gobs of disk space...
I looked around and found that you need a trailing backslash in the folder (see image) even though one is not entered by default when the target backup folder is selected... putting one in there will make this subplan piece actually work...
...and secondly, the extension text entry box will allow you to enter a period in this area, but will cause this sub plan to not work when it is there - so ".trn" will fail, while "trn" will actually succeed.
Enjoy! Hopefully this saves someone the hour I spent working this out.
-Matt G.
Not a question, but a quick note for those who get stuck with SQL Server admin stuff for handling their access backends (and don't do this all the time)...
I noticed that after I set up database maintenance plans on both my Sql Server 2005 and 2008 that the "maintenance cleanup task" wasn't removing my old .trn and .bak files even though the job shows success in the history... so they will taking up gobs of disk space...
I looked around and found that you need a trailing backslash in the folder (see image) even though one is not entered by default when the target backup folder is selected... putting one in there will make this subplan piece actually work...
...and secondly, the extension text entry box will allow you to enter a period in this area, but will cause this sub plan to not work when it is there - so ".trn" will fail, while "trn" will actually succeed.
Enjoy! Hopefully this saves someone the hour I spent working this out.
-Matt G.
