Post reply

Ghost cleanup

  • July 17, 2009 at 1:33 am

    #95565

    Hi,

    I have job which copy the database from one server to other. Before overwriting the database, we will make the database read write and then we will the kill the users connected to this database. after restoration, before making the database read only, job is failing. we observed that there is one backgroud process connected to the database called 'ghost cleanup' . Because of this, database can not be made read only. Please let me know how to get rid from the 'ghost cleanup' background process.

    Thanks a lot in advance.

    Regards,

    Jayant G Nimje

  • July 17, 2009 at 2:23 am

    #1026054

    That process cannot be killed, it's a system process. I don't think that process prevents you from setting the DB in read only: I suggest you investigate further to find the blocking process.

    Regards

    Gianluca

    -- Gianluca Sartori

  • December 16, 2009 at 5:35 am

    #1092931

    What is error message your are getting in the job?? Please provide the error code and error message of the job

  • December 16, 2009 at 5:53 am

    #1092941

    This thread is 5 months old, I hope the OP solved the issue long time ago.

    -- Gianluca Sartori

  • December 20, 2009 at 9:39 pm

    #1094581

    As this is system process, may be it was activating when I was about to make the database read write. To avoid this, I put wait for delay for 15 min before making the database read write. so once the 'ghost cleanup' finished it processing, I can make the database read write. This solution worked for me ! after updating this, I never got the error again...

    Simple trick I have applied to avoid the error !

    Thanks.

    Jayant

Viewing 5 posts - 1 through 4 (of 4 total)

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