Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Posts
    10

    Unanswered: restore master database

    ALL,

    When I attempt to restore a master database I am having some issues. I am using SQL Server 2000. I have set the start up option with -c -m to set the database in single user mode.

    When I run the restore from enterprise manager I am get an popup window that is titled "SQL-DMo(odbc SQLSTATE:HY000)" with not message and then the database conection is lost. Thus the master datbase is appears to it was not resotred. As when I close enterprise manager and then restart the MSSQLSERVER service the database is in the same state.

    Please advise on how i can get the Database restored.
    Thanks
    Chris

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Enterprise Manager takes up many connections to the server. You need to do the restore of the master database from Query Analyzer without the Object Browser running (hit F8, if it is up). When you use -m, the server is started in Single User mode. Use that single user wisely.

  3. #3
    Join Date
    Apr 2008
    Posts
    10
    from Query Anaylzer i get server error:


    Server: MSG 9001, Level 21, state 1 , Line 1

    Connection Broken

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    That is normal. SQL Server shuts down after the master database has been restored.

Posting Permissions

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