Re: Trans Log Maintenance

Tech-Archive recommends: Fix windows errors by optimizing your registry

Aaron,

I guess the question is with my current strategy (full recovery model,
hourly trans log backup, and nightly full backup) do I need to do anything
else to manage the log growth? i.e. truncate / dump logs occasionally.

Thanks

"Aaron Bertrand [SQL Server MVP]" wrote:

I don't understand, what is the problem? What part are you not able to
manage?




On 1/23/09 5:20 PM, in article
EA1B9539-D531-4867-A1D4-3EB656BB8FF1@xxxxxxxxxxxxx, "Socrates"
<Socrates@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi,

I'm trying to implement an efficient way to manage trans log in a prod
environment (recovery model full) with the following backup strategy:
- hourly trans log backups
- nightly full backups

Any help is greatly appreciated.

Thanks,




.