Deleting LOG FILES automatically

• ABHAY KUMAR

  Grasshopper

  Points: 20

  More actions

  January 23, 2004 at 2:49 am

  #107714

  Please suggest me a way where in the log files in SQL SERVER are deleted automaticallty at the end of the day at certain time.

• dbamark

  SSCommitted

  Points: 1694

  More actions

  January 23, 2004 at 6:52 am

  #491334

  Do you really want to delete them or just shrink them back to as close to original size as possible?

• dbamark

  SSCommitted

  Points: 1694

  More actions

  January 23, 2004 at 6:55 am

  #491336

  If all you want is to shrink them try:

   

  BACKUP LOG dbname WITH TRUNCATE_ONLY

  DBCC SHRINKFILE(dbname_Log, truncateonly)

• tosscrosby

  Hall of Fame

  Points: 3140

  More actions

  January 28, 2004 at 7:22 am

  #491940

  Be sure to do a full backup after the truncate_only. I'm wondering, what exactly are the ramifications of truncate_only? Is it only clearing unneeded transactions?

  
  Terry