Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151

    Unanswered: How to put Master db in single user mode !!!!

    How do you put the Master db in single user mode??? its not letting me from enterprise manager. is there a command if so can someone post it..

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    sqlservr.exe -c -m

    For more information, check 'Restoring the master Database from a Current Backup' in BOL.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    TIMBER

    You really sure you want to do this?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    plz tell me y i shounldnt do this

  5. #5
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Single User mode for the Master DB

    I think you need to re-phase the quetion. The Master db is the inner working of SQL Server. It's like the Systems db of Oracle. Why would you one to make a change like that? Any modification there will result in cascating errors threw all other database.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by hillcat
    How do you put the Master db in single user mode??? its not letting me from enterprise manager. is there a command if so can someone post it..

    How do you shut down an entire server?

    Why do you want to do this?

    M$ indicates that they will not support any user that modifies the systam tables, never mind the system databases

    The do talk about resoring or repairing corrupted system databases...

    Is that what you have?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    The problem is that my old sql server 2000 crashed and i had to reinstall i had all of my full back ups the only one i coundnlt restore was the Master db because it wasnt in single user mode.. the reason behind restoring the master is because all the database users are stored in the Master db ..so i think ...and i dont realy feel like creating them all over again. So what should i do ?

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd check the BOL for destructions on Restoring the master Database from a Current Backup.

    -PatP

  9. #9
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Arrow How to put Master db in single user mode !!!! Reply to Thread

    Test on Norhtwind, Go to the database and right click on properties. Last 2 tabs are the one you'll need.

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Also it sounds like you're trying to restore master from master...

    how are you doing this?

    isql, osql, EM, QA?

    Got any books?

    I highly recommend ADMIN 911 for sql servr 2000, Brian Knight

    I've never done this...but he suggests

    1. Rebuild master using rebuildm.exe
    2. Restart sql server in single user mode with the -m parameter
    3. Restore master from the last know good copy
    4. Verify all database are up and running
    5. Stop and start sql server
    6 Good to go


    Like I said I just reguritated what I have in front of me...get the book..

    Waaaaaaaay more info
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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