[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • Last Modified:

Restore master db

Hi All,
Using SQL 2005 , what is the best way to restore a backup of the master table to a new SQL Server instance from another server?

regards,
Bill
0
woyler
Asked:
woyler
  • 4
1 Solution
 
YveauCommented:
Ehm, Bill, It's the master database :-)
That is a nifty thing to do, but well documented by MS:

In general for system databases:
http://msdn2.microsoft.com/en-us/library/ms190190.aspx
more precisely for the master:
http://msdn2.microsoft.com/en-us/library/ms175535.aspx

Hope this helps ...

0
 
YveauCommented:
... make sure everything is exactly the same as on the old server, otherwise you will have some challenge !
Thinking of file locations, hardware, machine name ... just to mention a few.

Hope this helps ...
0
 
woylerAuthor Commented:
I guess my question , more specifically is the following;
I have full backups of Server A (all sys DBs and user db)  If Server A were to take a dirt nap and I needed to restore these backups to Server B, how do I get around the issue with the login accounts being restored?  I can restore all DB's except for the master , which contains the login info.  I have yet to find a solution that explains how to do this especially if the file structures  are different on the 2 servers.
I see you point out these issues in your 2nd response as challenges.  So what is best practice for a recovery scenario when you need to restore a DB to a different server?

thanks,
Bill
0
 
YveauCommented:
Install a 'empty' SQL Server, then restore the master as described in the articles.
All user databases will be marked 'suspect' as the files are not in place.
Remove all user databases and either
- restore them from a backup set
- attach them by pointing to the files (on the new location).

Everything should be back in business.

Hope this helps ...
0
 
YveauCommented:
Glad I could be of any help.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now