DB Maintenance Plan ?

What steps must be taken to ensure that during every
backup the transaction log does not build up? What must
be checked on the Transaction Log tab under the DB
maintaenance plan?
Thanks in advanceChris,
What I do is check the box that says "Remove files older
than:" and put 1 day in the box next to it. Also, I have
it back up the transaction logs every 2 hours so they
don't get huge. Every night we do a backup of the
machine, so I can restore from tape and then backup the
database to any point in time.
Hope this helps.
>--Original Message--
>What steps must be taken to ensure that during every
>backup the transaction log does not build up? What must
>be checked on the Transaction Log tab under the DB
>maintaenance plan?
>Thanks in advance
>.
>|||If once every two hours is not often enough to contain the
size of your tran log file(s), you can increase the
frequency of the log backups. It's not uncommon to backup
the tran log once every 15 minutes.
Linchi
>--Original Message--
>Chris,
>What I do is check the box that says "Remove files older
>than:" and put 1 day in the box next to it. Also, I have
>it back up the transaction logs every 2 hours so they
>don't get huge. Every night we do a backup of the
>machine, so I can restore from tape and then backup the
>database to any point in time.
>Hope this helps.
>
>>--Original Message--
>>What steps must be taken to ensure that during every
>>backup the transaction log does not build up? What must
>>be checked on the Transaction Log tab under the DB
>>maintaenance plan?
>>Thanks in advance
>>.
>.
>|||How can you determine the size of your transactionlog
files?
Thanks for you help.
>--Original Message--
>If once every two hours is not often enough to contain
the
>size of your tran log file(s), you can increase the
>frequency of the log backups. It's not uncommon to backup
>the tran log once every 15 minutes.
>Linchi
>>--Original Message--
>>Chris,
>>What I do is check the box that says "Remove files older
>>than:" and put 1 day in the box next to it. Also, I
have
>>it back up the transaction logs every 2 hours so they
>>don't get huge. Every night we do a backup of the
>>machine, so I can restore from tape and then backup the
>>database to any point in time.
>>Hope this helps.
>>
>>--Original Message--
>>What steps must be taken to ensure that during every
>>backup the transaction log does not build up? What
must
>>be checked on the Transaction Log tab under the DB
>>maintaenance plan?
>>Thanks in advance
>>.
>>.
>.
>