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 |
|
winman
Starting Member
26 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-14 : 00:47:00
|
| Even after taking backups if ldfs are growing then that means you're having some uncomitted open transactions which is highly intensive and filling up log space. Check for active transactions and see if you can execute them as batches rather than as a whole bunch------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-06 : 00:02:25
|
| Please change the recovery model set to Simple and shrink log files using DBCC Shrinkfile. Take regular backup's of database and perform a shrink files whenever the ldf file gorws. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-06 : 01:46:44
|
quote:
Originally posted by srimami
Please change the recovery model set to Simple and shrink log files using DBCC Shrinkfile. Take regular backup's of database and perform a shrink files whenever the ldf file gorws.
Need to analyse business impact before changing the recovery model like whether they require point in time recovery. Remember making recovery model as simple will truncate log after each checkpoint so point in time recovery will not possible once you make recovery model simple.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Size of the ldf file increasing