big size of database-log SQL-Server 2008
Posted
by
t.kehl
on Stack Overflow
See other posts from Stack Overflow
or by t.kehl
Published on 2012-03-18T17:53:32Z
Indexed on
2012/03/18
17:56 UTC
Read the original article
Hit count: 161
I have a database which is running under Microsoft SQL Server 2008. Now, I have seen, that the log of the database (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 ask me now, 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?
© Stack Overflow or respective owner