I am reviewing this: http://www.sqlservercentral.com/articles/Administration/64582/[/url].

I am concluding that I need to shrink the transaction log as a one-time operation.

Thanks...

I was thinking (mistakenly, no doubt) that the transaction log would not be needed when switching to simple recovery model.

So, let me pose the question: Given a transaction log...

At what point will my transaction logs go away?

Yes - the data is pulled from another database.

Thank you for your quick reply!

Will you meet me at the airport? 🙂

GilaMonster (5/11/2012)

---

Log backups once a day are not very useful. The main point of log backups is to allow point-in-time recovery, taking one a day means you could lose up...

Both.

So, since we do nightly log backups, if I look at backups of the server should I...

Lynn Pettis (5/11/2012)

---

Full backups and differential backups do nothing to clear the transaction logs. To do that you need to run scheduled transaction log backups.

Please read the last article...

Okay, part of what I read states:

"In full recovery model transaction log entries cannot be overwritten until they have been backed up by a transaction log backup....

"Without any...

I agree that either the model or the backup strategy needs to be addressed.

However, I think I have a...

Edogg said: "Log backups do not shrink...