Erratum: Subject: ldf file growing and growing
MS SQL Server 2005 on Windows 2003 SP1
2-3 hrs ago the ldf file of a DB started growing (reaching 6 GB) until the space on disk became 0. We made some space by deleting files but the space disappeared again. We don’t know what triggered this process.
There is only one program (SSIS) that writes to that database but that program is not active; at least we don’t see it.
We tried unsuccessfully to detach, take offline or shrink the database using Managment Studio: "the database is currently in use”.
- How could we detect which is the process hat has this effect?
- How could we reduce to a normal size the ldf file?
Thank you very much,
Dan