Home Forums SQL Server 2008 SQL Server 2008 Administration transaction log size reduction RE: transaction log size reduction
jpSQLDude
SSCrazy
Points: 2571
More actions
March 28, 2013 at 1:54 pm
#1601839
You said this database is Read Only?
If so, there should be no reason why you can't set it to Simple Recovery Model, then Shrink the Transaction Log file down to almost nothing, and I don't think it should ever grow again.