December 19, 2007 at 7:29 am
HI All we have a situation our server crashed, and we built a new server now I am restoring
all the user databases, msdb and model too . to get back the dts packages.
My question is do I have to restore the master databas also.
December 19, 2007 at 7:40 am
Do you want the new server to be same name as the other one? Do you need all the login informaiton? you have to look at it what do oyu need back and u can decide to restore master or not.
December 19, 2007 at 11:00 am
Like Amu said it depends on what you need. Really the only thing you will gain is login information.
The master db stores login information and a pointer to each database. If you have rebuilt a new instance, a new master db was created. You dont really need the pointer to the database because restoring a user database will create a new record, in the master database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply