Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Smile Unanswered: Issue with restoring master db

    Hi all,

    I am trying to restore my master database to a new server in sql 2000. I have started sql in single user mode from the command line and connected to enterprise manager and attempted to do the restore. I also tried query analyzer and used the restore database from disk ='file path of backup' used the move option with the correct file path and on both counts received the same error message...

    Error: 9001, Severity: 21, State: 1.
    Error: 3151, Severity: 21, State: 0.

    Any ideas? The connection is then broken (which I would expect anyway as restoring master shuts down sql but, I checked and it has not restored the db)

    Thanks!

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    This article may be of some help:

    http://www.dbarecovery.com/restoremasterdb.html
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    lmao @ your sig ... rdjabarov ... nice one !!!
    Get yourself a copy of the The Holy Book

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

  4. #4
    Join Date
    Nov 2003
    Posts
    6
    That is mostly what I have done (did not need to do the rebuild part) When I try to do the restore it does not complete but generates the error messages I listed in my first posting. I have done this before and it worked but, for some reason it is not allowing me to do the restore but, is breaking the connection.

    Any other suggestions?

  5. #5
    Join Date
    Nov 2003
    Posts
    6
    I did some more checking - could there be an issue with one server having a windows service pack 3 and the other server having windows service pack 4?

Posting Permissions

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