SQL .ldf file growing out of control
We use OpManager build 7100 which monitors about 80 devices.
In a one month time period, the SQL database (running on SQL Server 2005) .ldf file has grown to over 8GB in size. The .mdf file is a manageable 220mb, but the .ldf file is out of control already.
Does anyone know what causes this, and more importantly what I can do about it?
I can't imagine that this is normal behavior for a SQL database.
In a one month time period, the SQL database (running on SQL Server 2005) .ldf file has grown to over 8GB in size. The .mdf file is a manageable 220mb, but the .ldf file is out of control already.
Does anyone know what causes this, and more importantly what I can do about it?
I can't imagine that this is normal behavior for a SQL database.