| Tibor Karaszi 2006-10-24, 6:28 pm |
| Don't use the same maint plans for the databases in full vs. simple mode. If you do, maint plan is a
little bit daft and doesn't remove old tlog backups for the ones in full mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"George Schneider" < georgedschneider@new
s.postalias> wrote in message
news:F2886839-6488-47B7-8AE6- 4C0E2E7294D6@microso
ft.com...[color=darkred]
> 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?
>
> "Tracy McKibben" wrote:
>
|