Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL 2000 issue with single user mode

Answered SQL 2000 issue with single user mode

  • Monday, November 19, 2012 10:57 AM
     
     
    Sign In to Vote
    0

    hi folks,

    i was warming up with disaster recovery on sql 2000. i have dome this exercise on 2008 & 2005 with no issues.

    i can not start the instance in single user mode. when i issue "sqlservr.exe -c -m" i am getting your sql server installation is corrupt or tampred with (sql registry version not same as server)

    all i did from a running server i stopped the server from tray and servicess i stopped my named instance. then i deleted teh master file from the folders.

    then i tried to start, as you know i fail to start.

    then using rebuildm.exe i rebuild the system files then able to start the service and server.

    now i am trying to restore my master backup !!. i can i put in single user mode?

    any thoughts!!!!!

     

All Replies

  • Monday, November 19, 2012 11:00 AM
    Moderator
     
     Answered
    Sign In to Vote
    2

    if you have named instance on SQL Server then you also need to pass -s parameter else you would get "tampered" error. You should go to services.msc and take the complete "path to executable" from there and add -c and -m

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    • Marked As Answer by harrison_123 Monday, November 19, 2012 11:26 AM
    •  
     
  • Monday, November 19, 2012 11:08 AM
     
     
    Sign In to Vote
    0
    can you please explain bit more
     
  • Monday, November 19, 2012 11:10 AM
     
     
    Sign In to Vote
    0

    i am using the link below

    http://www.dbarecovery.com/backup-and-recovery-exercises/sql-server-2000-disaster-recovery-exercises/sql-server-2000-restore-master-database.html

     
  • Monday, November 19, 2012 11:21 AM
     
     
    Sign In to Vote
    0
    understand what you mean. now i put that in single user mode i guess. i am trying to restore my master.
     
  • Monday, November 19, 2012 11:25 AM
    Moderator
     
     
    Sign In to Vote
    1
    As soon as master restore is complete, SQL would stop automatically.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

     
  • Monday, November 19, 2012 11:25 AM
     
     
    Sign In to Vote
    0

    got it. thanks balamukund. i have been fiddling with this in the last couple of hrs.

    cheers..

     
  • Monday, November 19, 2012 11:27 AM
    Moderator
     
     
    Sign In to Vote
    0

    got it. thanks balamukund. i have been fiddling with this in the last couple of hrs.

    cheers..


    Cheers!

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter