Problem dropping second log file 1

[ramam1]

Hi all,
I have a DB (MSSS 2005) with two log files. I ran this script to through query analyzer in the management tool to try and drop the second one:

dbcc shrinkfile (LogFileName, EMPTYFILE)
go
alter database DatabaseName
remove file LogFileName
go

It seems to run with success but when I right-click on the database and look at the files it still shows up. Que pasa?

 

[ramam1]

Answering my own question....
A refresh didn't show the change but exiting the management tool and relaunching a few hours later did the trick.

 

[mrdenny]

SSMS can cache the data. Always verify via querying the database engine.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog