Need help deleting a second log file.

• rj_murray

  Grasshopper

  Points: 16

  More actions

  August 18, 2008 at 8:06 pm

  #125732

  Hi All,

  I aquired a SQL Server database from another department and somehow someone had a second log file attached to this database. Does anyone know how to get rid of the second log file? I have scrunk it to .13 mb and can not get it any smaller and it will not let me delete it until it is empty. The other one has .5 mb in it and that is as small as I can get it! Any help would be greatly appreciated . . .

  Rick

• Luzi62

  Ten Centuries

  Points: 1218

  More actions

  August 19, 2008 at 4:45 am

  #859874

  Hi,

  try this:

  use "database"

  go

  DBCC SHRINKFILE

  ( "logfilename" , EMPTYFILE )

  go

  alter database "databasename" remove file "logfilename"

  go

  regards

• rj_murray

  Grasshopper

  Points: 16

  More actions

  August 20, 2008 at 8:40 am

  #860666

  YOU ARE THE MAN!!! THAT DID THE TRICK, WITHA BACKUP AFTER THE LAST STEP!!! THANKS SO MUCH 😛