Log file is Full: How to prevent it happening?

"The log file for database 'DW_BackRoom_RT' is full. Back up the
transaction log for the database to free up some log space."
Now I only know this way to deal with that manually,
Step1. in option , chance Recovery model from FULL to Simple.
Step2: go to task to manually shrink the log file
Step3: Change recovery model back from simple to FULL.
But by this way, I could get same problem again, the log file is fill,
and need free up.
Could you give an idea how to prevent this from happening? what and
how should I do?
Thanks a lot in advance for your help.If you are periodically wiping the transaction log, then it sounds like it
is of no importance to you so I'd recommend leaving in simple recovery mode.
If you decide that the log is needed for DR, set up a backup plan which
includes full database backups and regular log backups.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hello,
If the data is this database is not critical/non production you can set the
recovery model to SIMPLE. THis will make sure that after
each checkpoint data will be writtent o disk and clear the transaction log
file. Incase if the data is critical keep the Recovery model
to FULL and make sure that you schedule a transction log backup (BACKUP
LOG). SO after each transction log backup the
LDF file will be cleared. THis will help you to restrict the growth of LDF
file and log backups will help you to recover the
database if needed as welll as you can perform Point_IN_Time recovery if
needed.
Take a look into Recovery models in Books online.
Thanks
Hari
<danceli@.gmail.com> wrote in message
news:1171053424.553101.106320@.s48g2000cws.googlegroups.com...
> "The log file for database 'DW_BackRoom_RT' is full. Back up the
> transaction log for the database to free up some log space."
> Now I only know this way to deal with that manually,
> Step1. in option , chance Recovery model from FULL to Simple.
> Step2: go to task to manually shrink the log file
> Step3: Change recovery model back from simple to FULL.
> But by this way, I could get same problem again, the log file is fill,
> and need free up.
> Could you give an idea how to prevent this from happening? what and
> how should I do?
> Thanks a lot in advance for your help.
>