Post reply

Kill process in system dbs

  • October 5, 2009 at 5:08 am

    #215098

    Hi.

    How can I to kill a process in Master db? The problem is that when i am running an update the server restart and when star again a process token unknow in master db is blocking a table of my db.

    I like to kill this process to unblock this table.

    Thanks.

  • October 5, 2009 at 5:14 am

    #1061641

    javier varas (10/5/2009)

    Hi.

    How can I to kill a process in Master db? The problem is that when i am running an update the server restart and when star again a process token unknow in master db is blocking a table of my db.

    I like to kill this process to unblock this table.

    Thanks.

    You shouldnt be killing any process without knowing exactly what it is doing, if the server restarts, then all existing processes would be closed, so you shouldnt have a problem when the server restarts. I would be more concerned about why you have a blocking process after the server has restarted. can you post any information on it, the process in master might be down to a database recovery/integrity check.

    Is there any thing listed in the sql logs or windows event logs.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 6, 2009 at 1:04 am

    #1062109

    Is certain. After read the log, i can see that the database is recovering, when finish my table are online again.

    Thanks.

  • October 6, 2009 at 1:33 am

    #1062114

    np, glad to know it is fixed

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

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