| Tracy McKibben 2006-10-24, 6:28 pm |
| George Schneider wrote:
> Now I'm back to square one. I thought the problem with not removing the
> tranaction backups was becuase I was running backups on db's that were in
> simple recovery mode. This is not the case. I have some db's in simple and
> some in full recovery mode. The one's in simple recovery mode are fine and
> do not have a tranaction log backup created. Its the four pr have db's that
> are in full recovery mode. The tranaction logs backups are not being deleted
> like the bak files from the backup directory. What can be causing this and
> how cna I resolve this?
>
The problem is that you're doing all of this from ONE maintenance plan,
and have told the maintenance plan to do transaction log backups of ALL
your databases. When it attempts to do that, it fails on the ones that
are in Simple mode, and never gets to the cleanup step where it deletes
the old files.
Create two seperate maintenance plans, one for the Simple mode
databases, one for the others. OR, better yet, dump the maintenance
plan altogether and use scripts to perform these tasks. Here is one:
http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|