October 21, 2005 at 9:20 am
I am in the middle of rolling back sp4 on one of our test sql servers.
I have uninstalled and reinstalled SQL and now need to restore the master db from a couple of days ago.
I am getting the following error and believe I know what the problem may be:
Login failed for user 'sa'. Reason: Server is in single user mode. Only one administrator can connect at this time.
I have started sql server in single user mode via a dos prompt and one of the other guys is trying to do the restore. I believe the error is due to 2 different logins attempting to use the master db at the same time.
Myself: starting sql in single user mode
Backup User: trying to do the restore.
Any thoughts would be appreciated.
Carl
PS I have also posted this question on the Backup forum.
October 21, 2005 at 9:35 am
Don't cross post, People usually look across all the boards Finish it up here
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=231206
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply