Large transaction logs
Posted on 2006-05-23
Good morning all
Currently, i have 2 servers with transaction logs of 21GB (on a 34GB drive) and 41GB (on two drives - 21 and 20) . Both have unexpectedly jumped size and i now face the dilemma of 2 choices : installing an fresh set of drives or trying to prune them in some way. With limited disk space, though, they won't shrink any more and my question comes to this :
Can i truncate the log without damaging the actual database then shrink ? If so, how to, especially on the database with the two log files ? Mind you it has been storing transactions for the past 5 years and no-one sat down to fix it.
db_Log is on a RAID5 with 800mb free.
db_Log2 is on a single drive with 10GB free.
I do have the flexibility of 3 drives that i have sitting beside me at the moment
Any solutions ?