Post reply

GOST CLEANUP prevents detaching database

  • August 20, 2010 at 6:56 am

    #146690

    I have a database on a cluster that needs to be dropped its not being used anymore. I have noticed that a system process has been running on this database since 8/13/2010 and its command is GHOST CLEANUP. I cannot kill the command because its a system command.

    Do I have any options other than restarting the instance? I really don't want to restart the instance because there are many other production databases on this instance.

    I have used the following article to find out that the GHOST CLEANUP has been running since 8/13/2010.

    http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Ghost-cleanup-in-depth.aspx

  • August 20, 2010 at 7:21 am

    #1209644

    Nervermind I was able to resolve this problem. If anyone has this problem you can try the following it worked for me.

    ALTER DATABASE databaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DROP DATABASE databaseName

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply