My log file is so big, after truncate it 2 days, it still big like before
- by tranvinhnt
I'm using sql server 2005 and the log is too big 23 gbs (if you compare with the data file only 8GB).
I've already run the truncate, after that the log file is 24mb but after 2 days, it becomes 23gbs.
My database is full backup mode. I have the maintain plan is 2 hours will have diff backup and 24hours will have full backup.
Do you have any idea about this case?
