LOG file growing unexpectedly
-
Month before, One of my database size was 15GB. But today i have looked it , it grows to 35GB. In which MDF(Data file) Size is 13603584 KB and LDF(Log File) sixe is 39793536 KB. after analyzing it for a few hours i had seen growth of Log files is so fast. i ran sp_dboption '', 'trunc. log on chkpt.', 'TRUE' CHECKPOINT use master Go EXEC sp_configure 'show advanced option', '1' RECONFIGURE EXEC sp_configure USe GO DBCC SHRINKFILE (_LOG, 1) GO But it does not help me. kindly let me know how to truncate it or How to reduce log file size.?? thanks in advance.
-
Month before, One of my database size was 15GB. But today i have looked it , it grows to 35GB. In which MDF(Data file) Size is 13603584 KB and LDF(Log File) sixe is 39793536 KB. after analyzing it for a few hours i had seen growth of Log files is so fast. i ran sp_dboption '', 'trunc. log on chkpt.', 'TRUE' CHECKPOINT use master Go EXEC sp_configure 'show advanced option', '1' RECONFIGURE EXEC sp_configure USe GO DBCC SHRINKFILE (_LOG, 1) GO But it does not help me. kindly let me know how to truncate it or How to reduce log file size.?? thanks in advance.