Posted by barlowedward@hotmail.com on 05/22/07 12:32

If your tran log gets that big you should decide if you care about
tran logs

either

set recovery mode to simple, dump tran with nolog, shrink the database
log file, and take a backup

-or-

set up incrementals using your maintenance plan

-or-

both

if you need point in time recovery, i recommend doing both. Eliminate
the old junk and redump your
database after setting up a plan that dumps tran logs.

Ed

• Next in forum: Transaction log and tempdb
• Prev in forum: Re: Getting Result of query inside another query
• Thread view: Re: Transaction log file size - does it do any harm?

[Reply to this message]