Log file issue

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  November 13, 2003 at 8:17 am

  #81528

  my Log file has grown to a very large size for the last two days(from 1 GB to 9 GB).What should be the reason and how can i see the free space in my databse.

  Thanks.

• philcart

  SSC-Forever

  Points: 47797

  More actions

  November 13, 2003 at 3:26 pm

  #481981

  What is the recovery model for the database?

  Do you do transaction log backups?

  Has there been any large updates to the database, or any reindexing? Both of these operations can cause the log file to grow.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface

• iadams

  SSCommitted

  Points: 1970

  More actions

  November 17, 2003 at 10:49 am

  #482254

  Simple way to view space used vs free space is:

  Open EM

  Right-click over the database in question

  Choose View-->Taskpad

  You will see the database and Log files at the bottom of the display.

  Also look into backing up the transaction log more often, to manage its growth.

  Have a look in BOL for:

  DBCC SHRINKDATABASE

  ( database_name [ , target_percent ]

  [ , { NOTRUNCATE | TRUNCATEONLY } ]

  )

  Use this Wisely!

  I suspect you have someone connecting to the database in question, and their executing mass loads of data and mass deletes, over and over again. Otherwise you will see the database grow as well as the log.

  You can put a trace on the database to find out what/who is loading so much data.

  Good Luck

  -Isaiah

  
  -Isaiah