transation log file

• saddoness

  Newbie

  Points: 7

  More actions

  February 19, 2010 at 12:19 pm

  #137304

  hi all,

  I have 2 log files from my database ,

  D:/database_log.LDF(primary)

  F:/database_log1.LDF

  I try to delete database_log1.LDF,but received menssage of error because file is not empty.

  How can delete secundary log file ?

  att

  Paul

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  February 19, 2010 at 3:41 pm

  #1122187

  First try to empty the file and then remove it..If it can not be emptied, then can not be removed....

  USE [database]

  GO

  DBCC SHRINKFILE (file2_log' , EMPTYFILE)

  GO

  USE [database]

  GO

  ALTER DATABASE [GLP] REMOVE FILE file2_log

  GO

  -VG