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.
Please advise on what the best practice is.
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.
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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@gupshup -- thanks.
Glad to help.
Glad to help.
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).