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: 157

Filed under:
|
|

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

Related posts about sql-server-2008

Related posts about size