Post reply

SQL Server Single User Mode - Situation?

  • June 16, 2017 at 4:21 am

    #324102

    Hello,

    Can anybody please make me understand that under which situtaion a DBA will have only one option that to start sql server instance in single user mode do some kind of urgent maintenance activitites? Any realtime or self faced scenario? Thanks in advance.

    Regards
    VG

  • June 16, 2017 at 4:23 am

    #1947063

    Vivek

    Restoring the master database is one.

    John

  • June 16, 2017 at 5:07 am

    #1947071

    John Mitchell-245523 - Friday, June 16, 2017 4:23 AM

    Vivek

    Restoring the master database is one.

    John

    Because Master database is always in use by database? Am I sounding right?

    Regards
    VG

  • June 16, 2017 at 5:14 am

    #1947073

    Just because, really.  You can't restore master unless you're in single user mode.  That's how the product works.  Probably is something to do with master always being in use, though.

    John

  • June 16, 2017 at 6:21 am

    #1947088

    Thanks John 🙂

    Regards
    VG

  • June 16, 2017 at 7:06 am

    #1947098

    I've had to use it to reset the sa password in order to gain access to the server.  Previous administrator had lost the password and Built-in admins were removed at install time.

  • June 20, 2017 at 12:29 am

    #1947339

    We had an issue once with tempdb.
    Someone read about secondary data files and contention. So obviously he created 15 LOG files for tempdb.
     DBCC EMPTYFILE was not sufficient, so we had to start SQL Server with minimal configuration mode (still single user) and repair the tempdb files there.

    ________________________________________________________________
    "Accept conditions as they exist, or accept the responsibility for changing them."

Viewing 7 posts - 1 through 6 (of 6 total)

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