Problem trying to restore master database

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  October 21, 2005 at 9:17 am

  #166008

  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

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 21, 2005 at 9:34 am

  #599168

  Single user mode means just that, you guys are gonna have to share, and take turns.