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 |
|
cijojohn
Starting Member
3 Posts |
 Posted - 2009-12-07 : 12:57:32
|
| I have sqlserver 2008.My ldf file is growing too big Now its 126 GB and my mdf file is only 328 MB.I need to reduce the size of LDf file. How to do it?If I’m shrinking the ldf file the size is coming to 16 GB.And I gave the autogrowth option checked for ldf file and file growth given as 100 MB.i opted maximum file size as 2000 GB.Is this setting ok? Whenever new transaction happens the log file will grow beyond 16 GB right?Any help is appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cijojohn
Starting Member
3 Posts |
Posted - 2009-12-07 : 14:18:42
|
| so you mean to say that after shrinking, change the recovery mode to Simple? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-12-07 : 14:32:20
|
| No. Don't shrink it until you've either change to SIMPLE recovery model or started backing up the tlog on a regular basis. What recovery model you use depends upon what recovery options you want. We must have point in time recovery option here, so we can not use SIMPLE in production. We do use SIMPLE in dev/test though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-08 : 03:35:05
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
LDF file growing too big