March 26, 2004 at 11:23 am
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
March 26, 2004 at 11:37 am
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.
March 27, 2004 at 9:48 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy