Wednesday, March 21, 2012

Maintanence Plans

I am having trouble with my database maintanence plan.
It will work ok for a while, then it just stops working, but even when it is
working it won't delete the old .BAK file's like it is supposed to.
Dan,
Check if you plan is running log backups of databases which have their
recovery model set to simple. In these cases the database maintenance plan
runs ok until the invalid log backup occurs, and the plan terminates with a
somewhat misleading error, without deleting the old backup files.
Jon Jahren
"Dan Thannhauser" <DanThannhauser@.discussions.microsoft.com> wrote in
message news:10178E9F-0E25-413A-AFC4-6C38A662C8D2@.microsoft.com...
> I am having trouble with my database maintanence plan.
> It will work ok for a while, then it just stops working, but even when it
is
> working it won't delete the old .BAK file's like it is supposed to.

No comments:

Post a Comment