Transaction Log size getting bigger?

• andy-232663

  SSChasing Mays

  Points: 603

  More actions

  July 8, 2005 at 7:10 am

  #110570

  My database size is 16 GB, but log size is getting bigger and bigger 15 GB.

  What should i do reduce the size without loosing any data.how can i do this please suggest

  Thanks

• Rafter

  SSC-Addicted

  Points: 472

  More actions

  July 8, 2005 at 7:29 am

  #572309

  First of all check to see how much of the log is being used

  dbcc sqlperf(logspace)

  If the logspace is heavilly utilised then I'd look at setting up maintanance plan to backup up you logs on a regulare basis.

   

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  July 8, 2005 at 7:31 am

  #572311

  The transaction log grows with every DELETE, INSERT, or UPDATE (in other words ANY transaction) that you do to the data.

  You can SHRINK the transaction log.

  You can TRUNCATE the transaction log.

  You can ignore it and let it grow.

  BTW-do you backup your transaction log? If not, then switch your recovery mode to simple and ignore it.

  But, if you need to be able to do a up-to-the-minute restore, then you need the transaction log and need to be backing it up.

  Refer to the BOL for more information about the Transaction Log and how to handle it.

  BOL=Books OnLine=Microsoft SQL Server's HELP

  Installed as part of the Client Tools

  Found at Start>Programs>Microsoft SQL Server>Books OnLine

  or online at:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

  -SQLBill