MS SQL Server - Maintenance Plan

Author

Maintenance Plan

Brandon

2006-10-28, 7:14 pm

I have a maintenance plan that is setup to delete backup files older than x
days. And it was deleting the files just fine until a few days ago . . .
now it will not delete older files. I even setup a new maintenance plan and
it still won't delete older files. Any idea as to why?

--
Brandon

==================
Presentations Direct - http://www.presentationsdirect.com
> Binding Machines
http://www.presentationsdirect.com/...ng-machines.asp
> Laminators
http://www.presentationsdirect.com/...-laminators.asp
> Paper Shredders
http://www.presentationsdirect.com/...r-shredders.asp
==================

Kevin3NF

2006-10-28, 7:14 pm

Check all the databases in the plan. If any of them are in Simple Recovery
model, this may be the issue.

2000, or 2005?

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com

"Brandon" < bsmith@presentations
direct.nospam.com> wrote in message
news:OZkIa2c%23GHA.2180@TK2MSFTNGP05.phx.gbl...
>I have a maintenance plan that is setup to delete backup files older than x
>days. And it was deleting the files just fine until a few days ago . . .
>now it will not delete older files. I even setup a new maintenance plan
>and it still won't delete older files. Any idea as to why?
>
> --
> Brandon
>
> ==================
> Presentations Direct - http://www.presentationsdirect.com
>
> http://www.presentationsdirect.com/...ng-machines.asp
> http://www.presentationsdirect.com/...-laminators.asp
>
> http://www.presentationsdirect.com/...r-shredders.asp
> ==================
>

Brandon

2006-10-28, 7:14 pm

SQL 2000 . . . none are in simple mode.

--
Brandon

==================
Presentations Direct - http://www.presentationsdirect.com
> Binding Machines
http://www.presentationsdirect.com/...ng-machines.asp
> Laminators
http://www.presentationsdirect.com/...-laminators.asp
> Paper Shredders
http://www.presentationsdirect.com/...r-shredders.asp
==================
"Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message
news:%23SsIogd%23GHA
.1220@TK2MSFTNGP05.phx.gbl...
> Check all the databases in the plan. If any of them are in Simple
> Recovery model, this may be the issue.
>
> 2000, or 2005?
>
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> http://kevin3nf.blogspot.com
>
>
> "Brandon" < bsmith@presentations
direct.nospam.com> wrote in message
> news:OZkIa2c%23GHA.2180@TK2MSFTNGP05.phx.gbl...
>
>

Sponsored Links