Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jarablue
Starting Member
9 Posts |
 Posted - 2011-12-19 : 04:41:04
|
| I'm trying to get rid of the transaction log but I can't due to open processes. Is there a way to do this relatively easy?Thanks so much for the help! :) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-19 : 04:46:59
|
| what do you mean by get rid of transaction log?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-12-19 : 12:38:13
|
| You can't "get rid of" the transaction log. It is required by the database. You can manage its growth though. If your recovery model is set to FULL, then you need to backup the tlog frequently, such as every 15 minutes. If you don't require these recovery points, then you can consider switching to SIMPLE recovery model. Either way you go and if you haven't been doing one of these all along, you can do a one-time shrink to get it down to a manageable size.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-19 : 13:02:20
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Cant truncate transaction log...open db processes?