Post reply

starting sql server

  • March 26, 2013 at 1:15 am

    #272147

    Is this possible to restart the sql server in single user mode

    if yes is there any impact on server

  • March 26, 2013 at 4:33 am

    #1600695

    Yes you can start the server in single user mode.

    Impact well only 1 person at a time can connect

  • March 26, 2013 at 4:40 am

    #1600702

    New persopn (3/26/2013)

    if yes is there any impact on server

    Impact, you kill all user connections (by restarting the service) then single user mode allows only a single user to connect.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 26, 2013 at 2:18 pm

    #1600962

    Reminder, SQLAgent is a user. this wont help you do any jobs.

    .

  • March 27, 2013 at 12:51 pm

    #1601327

    What do you want to start it in single user mode? Typically this is reserved for restoring master or if there are major problems with SQL Server you put it in single user mode to diagnose severe issues.

    And yes, SQLAgent connects to SQLServer and is a user so if you do this make sure you stop the SQLAgent Service.

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

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