I have a database which is running under Microsoft SQL Server 2008. Now, I have seen that the log of the database (the
.ldf file) is growing to big size. The database file (
.mdf) has a size of 630MB and the log file has a size of 12GB. I wonder what the reason for this can be. Is there a tool which let me seeing into the log where I can see, what is the reason for this big size?
What can I do to prevent that the log is growing to this big size?