I am running SQL Server 7.0, I have a sizable database with a LOT of activity. Within a weeks time the Transaction Log has grown to over a gig.<BR><BR>I&#039m new to SQL Server (just switched from Access), what is the best way to maintain this transaction log? I&#039m going to put the data onto a new 30gig drive, but I&#039d prefer if the Transaction Log didn&#039t take it all up :o)<BR><BR>Also, I have run the Truncate Option for transaction logs, it didn&#039t trim it by much.