September 13, 2002 at 6:43 am
My transaction logs are constantly getting filled. I run full backups on a nightly basis, differentials every 3 hours during the day, and transaction backups every 15 mins during the day. Should I be using the With Truncate state in my Transaction Log backup? What is the best method to keeping your Transaction logs from going out of control?
Thanks for the help
September 13, 2002 at 8:12 am
Standard tran log backup should do it. Maybe the log is just not big enough? Index rebuilds will generate a lot of transactions. Replication can cause the log to not get truncated if the log reader hasn't cleared transactions.
Andy
September 13, 2002 at 4:23 pm
If SQL 2000 check the recovery model in the database option. Maybe you should reconsider changing to another mode if the Full mode is being used.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply