+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, SQL single user mode in Technical; I need to get my SQL server into single user mode so I can restore the master database. I've read ...
  1. #1

    Join Date
    Sep 2007
    Posts
    181
    Thank Post
    4
    Thanked 2 Times in 2 Posts
    Rep Power
    14

    SQL single user mode

    I need to get my SQL server into single user mode so I can restore the master database.

    I've read about the -m switch but this doesn't seem to work.

    What's the easiest way of doing this? Can it be done via the SQL management studio?
    Last edited by AnnDroyd; 2nd May 2008 at 08:18 AM.

  2. #2
    Jona's Avatar
    Join Date
    May 2007
    Location
    Cranleigh
    Posts
    462
    Thank Post
    14
    Thanked 47 Times in 46 Posts
    Rep Power
    23

  3. #3
    Jona's Avatar
    Join Date
    May 2007
    Location
    Cranleigh
    Posts
    462
    Thank Post
    14
    Thanked 47 Times in 46 Posts
    Rep Power
    23
    Well assuming that tutorial is correct stop SQL server process then go

    start > run > C:\Program Files\Microsoft SQL Server\MSSQL\BINN\sqlservr -m

    ??

  4. #4
    Iain's Avatar
    Join Date
    Oct 2006
    Location
    Warwickshire
    Posts
    178
    Thank Post
    27
    Thanked 87 Times in 49 Posts
    Rep Power
    30
    Or add the -m switch to the startup parameter list under the properties of the server in the management console, and then restart the server process?
    Attached Images Attached Images

SHARE:
+ Post New Thread

Similar Threads

  1. Active Directory - Single and Bulk User creation and FREE!!
    By siuko in forum How do you do....it?
    Replies: 39
    Last Post: 20th June 2012, 11:29 AM
  2. Vbscript reset a single domain user's password
    By ryan_powell in forum Scripts
    Replies: 9
    Last Post: 4th June 2009, 02:43 PM
  3. Make a script run for SINGLE domain user
    By philtomo-25 in forum How do you do....it?
    Replies: 5
    Last Post: 15th November 2007, 09:21 PM
  4. Compatibility Mode
    By cokecan72 in forum Windows
    Replies: 2
    Last Post: 29th June 2007, 01:13 PM
  5. sql server single user
    By Uraken in forum Windows
    Replies: 0
    Last Post: 18th May 2007, 12:29 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •