hi we are using SQL Server 2005, Last Two days faced space issue in our Server drive.
After complete analysis the LDF file size is 21 GB.
But normally it will be in 190-300 MB Only.
No Bulk update/insert taking place.
So can any one tell me
what is the cause of sudden increase of LDF file and how to stop growing and prevent measure to follow in future??
Check the value of
answered Dec 04, 2012 at 09:47 AM
Kev Riley ♦♦
which recovery mode is used run this query to find out recovery model of your database select name, recovery_model_desc from sys.databases where name like 'dbname'
if you database is in FULL recovery mode, then how frequently do you take transaction log backup.
generally when there is high number of transaction, it may not be user level transaction but maintenace plans or jobs might be the reason for ldf file size increase
answered Dec 05, 2012 at 06:55 AM