master db restore

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dishan Fernando

    master db restore

    Hi.,
    Can restore master database and other databases from one server to
    other. I cant restore master database. i stared server in single user
    mode, and restore master database. it says successfully restored and
    server stoped. I cant up the server... :(

    Regards
    dishan

  • John Bell

    #2
    Re: master db restore

    Hi

    You will need to check the SQL Server log to see why. Assuming you have
    taken a backup of the previous master you can restore it back to the
    original and then follow the instructions in:




    John

    "Dishan Fernando" <dishan@gmail.c om> wrote in message
    news:1103769554 .879470.30360@c 13g2000cwb.goog legroups.com...[color=blue]
    > Hi.,
    > Can restore master database and other databases from one server to
    > other. I cant restore master database. i stared server in single user
    > mode, and restore master database. it says successfully restored and
    > server stoped. I cant up the server... :(
    >
    > Regards
    > dishan
    >[/color]


    Comment

    • John Bell

      #3
      Re: master db restore

      Hi

      I mised this link:


      John

      "John Bell" <jbellnewsposts @hotmail.com> wrote in message
      news:41cad06f$0 $26136$afc38c87 @news.easynet.c o.uk...[color=blue]
      > Hi
      >
      > You will need to check the SQL Server log to see why. Assuming you have
      > taken a backup of the previous master you can restore it back to the
      > original and then follow the instructions in:
      >
      > http://support.microsoft.com/kb/224071/EN-US/
      > http://support.microsoft.com/default...;en-us;Q314546
      >
      > John
      >
      > "Dishan Fernando" <dishan@gmail.c om> wrote in message
      > news:1103769554 .879470.30360@c 13g2000cwb.goog legroups.com...[color=green]
      >> Hi.,
      >> Can restore master database and other databases from one server to
      >> other. I cant restore master database. i stared server in single user
      >> mode, and restore master database. it says successfully restored and
      >> server stoped. I cant up the server... :(
      >>
      >> Regards
      >> dishan
      >>[/color]
      >
      >[/color]


      Comment

      Working...