How can I revert back to using a single log file

• Dave -310292

  SSC-Addicted

  Points: 440

  More actions

  March 14, 2006 at 12:04 pm

  #116437

  It has come to my attention that not only has my log file been set to autogrow, but at some point it was also expanded to a separate physical location.  The result is now I have two log files.  I run the database in simple recovery mode, and there is plenty of space in my original location.  Not to mentioin that I am now getting Q'd I/O's on the disk the second partition was expanded to. 

   

  My question is how can I revert back to using only the original log file.  Ideally I need to do this on the fly without the end users being aware.  A restart can be done later if needed

   

  Thanks

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  March 14, 2006 at 1:16 pm

  #626635

  The log file to be deleted needs to be empty before deletion, use this script to get what you need.

  DBCC

  SHRINKFILE ([YourTransLog] , EMPTYFILE)

   

  USE

  master

  GO

  ALTER

  DATABASE YourDatabase

  REMOVE

  FILE [YourTransLog]

  GO