Link to home
Start Free TrialLog in
Avatar of gupshup
gupshup

asked on

msdb, master, model

I am restoring backup files of msdb, model, master.  I have been told not to restore master so I am not.  What about msdb and model.  Is it ok to just restore these databases or is it best to take the info from them an put it on the new msdb and model.  If i should restore both of them what order should i do it in and also what steps shoudl i take?
Please advise on what the best practice is.


Avatar of danblake
danblake

Did you actually read this ?
http://support.microsoft.com/default.aspx?scid=kb;en-us;264474

You only need to use the RESTORE database command and you can restore the master database too ! (But you will not be able to restore them from SQL 7 -> 2000 for instance or a different patched version of a server).
Avatar of gupshup

ASKER

Yes I read it however my concern is that, the server I am planning to restore my msdb , model and master database on is a server that I need information from.  I understand i can just copy my dts files from the server I am going to overwrite, but is that good enough.  Is there anything else that I need to take besides jobs, dts packages(which i can take from the msdb bak) before i copy the new msdb, model, master to the server?  

Yes I read the article however that does not apply to me since my servers are the same build.
It also details how to restore the key-system databases.  (so the article does apply in your situation -- as a quick guide it also gives good hints where to find the information for the other databases ...).
Its a little difficult to translate in a single server-single server restore situation.

But here is the hints it gives...
Restore Master Database:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp

Msbd Databases: (Restoring model, msdb, distribution databases...)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp


The MSDB database/other database are used with the RESTORE db command, which can be found at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_18ah.asp
Avatar of gupshup

ASKER

Danblake,

Thanks for the links:

Is it ok to restore the msdb and model databases and not the master?
Also if I am restoring the databases, which order should I do them in?

gupshup
ASKER CERTIFIED SOLUTION
Avatar of danblake
danblake

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@gupshup -- thanks.

Glad to help.