Database in Single User mode - cannot kill SPID

  • Help!

    I have a 1 database (out of 7) which has gone into single user mode. I have change the mode to multi or restricted without success as ent mgr says a user is connected. I then tried to kill the process ID which was logged on (3 processes all with cmd killed/rollback) . I get the following message:

    SPID 58: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.

    Any help would be appreciated...!

    Paul

  • If it is a job process you can try stopping the SQL Agent. If not I think you will have to restart the sql server.

     

    If after rebooting, the process connect again to the database. You can start the server in single user mode, connect and change the status of your db.

  • Managed to find a gap to reboot the server and all is back to normal - thanks for the advice!

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

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