Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008

    Unanswered: restore of master DB


    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.

  2. #2
    Join Date
    Oct 2001
    Usually you can't use enterprise manager in single user mode because it runs things in different connections.
    Try doing the restore using query analyser.

Posting Permissions

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