After Master is restored

After restoring Master, is it ALWAYS necessary to also restore MSDB?
Message posted via http://www.sqlmonster.com
Robert
No it is not always necessary, it depends on what you are doing. If for
instance you had a corrupt master database for some reason, but your other
databases were fine then there would be no need.
On the other hand if you were moving all your databases from one server to
another, you would want to restore msdb, as long as you were using it. (had
some Jobs, alerts or operators on it).
I would say only restore what you need to.
Hope this helps
John
"Robert Richards via SQLMonster.com" wrote:

> After restoring Master, is it ALWAYS necessary to also restore MSDB?
> --
> Message posted via http://www.sqlmonster.com
>

After Master is restored

After restoring Master, is it ALWAYS necessary to also restore MSDB?
Message posted via http://www.droptable.comRobert
No it is not always necessary, it depends on what you are doing. If for
instance you had a corrupt master database for some reason, but your other
databases were fine then there would be no need.
On the other hand if you were moving all your databases from one server to
another, you would want to restore msdb, as long as you were using it. (had
some Jobs, alerts or operators on it).
I would say only restore what you need to.
Hope this helps
John
"Robert Richards via droptable.com" wrote:

> After restoring Master, is it ALWAYS necessary to also restore MSDB?
> --
> Message posted via http://www.droptable.com
>