Huge log files under SQL Server 7

• PAUL717

  SSC-Addicted

  Points: 478

  More actions

  July 17, 2002 at 1:08 am

  #173212

  Hi,

  I've got some troubles to reduce Log allocation space.

  With SQL2000 I used the folowing script with good results:

  -- BACKUP DU LOG

  BACKUP LOG eluxembourg

  WITH TRUNCATE_ONLY

  -- TRUNCATE DE LA DB

  DBCC SHRINKDATABASE (eluxembourg, TRUNCATEONLY)

  -- VIDE LE LOG

  DBCC SHRINKFILE (eluxembourg_LOG, EMPTYFILE)

  But it does not reducing the log on SQL Server7

  why ?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 17, 2002 at 5:18 am

  #432859

  SQL7 requires a little more work. Shouldnt, but it does. Basically you have to generate filler transactions in the log to get it to move to the next virtual log segment. We've got a a link to a script around here somewhere that will do it for you...Antares, got it handy?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  July 17, 2002 at 5:47 am

  #432865

  Here is Steve's posted script:

  http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley

• PAUL717

  SSC-Addicted

  Points: 478

  More actions

  July 17, 2002 at 7:34 am

  #432878

  Wow, it does the job!

  Thanks.