I have a SQL 2012 DB where the *.mdf file is 4+GB and the log (*.ldf) is 50 GB.

  • I have a SQL 2012 DB where the *.mdf file is 4+GB and the log (*.ldf) is 50 GB.

    The DB is in SIMPLE RECOVERY.

  • Is there a question here?  Making a guess, it is possible that the transaction log file has grown to 50GB based on activity.  One thing I would also look at is how much space is being used in the transaction log.  If it is mostly empty then it points to simple usage.  If there is very little empty space then there could be another issue.  In this second case I would then run the following:

    SELECT [name], [log_reuse_wait_desc] from sys.databases where [name] = 'your database name here';

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply