Announcement Banner
UNSOLVED

zhaos2

updated

15 years ago

Z

zhaos2

2 Intern

•

643 Posts

0

950

February 29th, 2012 23:00

Master Database Restore

If I want to restore the backup Master Database to another server, is there anything I need to consider?

  • 404

    1

    Posted March 1st, 2012 06:00

    Hi zhaos

    You dont explain your scenario for having to do this, great if you could ? It can be a pain moving, rebuilding master so generally best avoided.

    However there was an intersting TechNet blog post on this topic a few weeks ago, suggesting restore the master  to another instance as another database, steps explained in the link, havnt tested this out in the lab so cant stress enough ...test before using.

    http://blogs.technet.com/b/fort_sql/archive/2011/02/01/the-easiest-way-to-rebuild-the-sql-server-master-database.aspx

    Michael

  • zhaos2

    2 Intern

    •

    643 Posts

    404

    0

    Posted March 1st, 2012 19:00

    Thanks Michael for your helpful answer!

    The scenario could be Master DB corrupted or server failed.  The article you reccomended is very good guideline for Master DB restore, and the version match between source and target SQL server is critical for success restore.

    Simon