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

    Unanswered: restore of master DB

    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
    Oct 2001
    Location
    England
    Posts
    426
    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
  •