Rebuilding the Master Database

Hi
I thought that I had this procedure down pat, but just got
hit. What I am trying to do is change the collation
setting for the entire database. These settings only have
to apply to NEW databases, so the old ones I am dettaching
and then reattaching them after the rebuild.
The problem lies in that there are users and DTS packages
that are saved in the old MASTER and MSDB databases, and
when I restore them from old backups, the following
happens.
1) I cannot seem to recover the DTS packages.
2) The collation settings for these two databases revert
to the previous setting.
Any help please or is there a fool proof method of doing
this.
Cheers
PaulIt is not supported to have different collations between the system databases, so rebuild and then
restore a system database is not the way to go (because as you have noticed, you get the old
collation when you restore). So, do a rebuild and then re-create the stuff in master and msdb. You
can script jobs etc for msdb in EM. As for master, most important is probably logins, see KB's
listed below. But don't forget that there are other things to consider as well (sysconfigures,
sysservers etc).
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Paul Blackler" <pblackler@.themis.co.uk> wrote in message
news:084001c3adcd$e5b65aa0$a501280a@.phx.gbl...
> Hi
> I thought that I had this procedure down pat, but just got
> hit. What I am trying to do is change the collation
> setting for the entire database. These settings only have
> to apply to NEW databases, so the old ones I am dettaching
> and then reattaching them after the rebuild.
> The problem lies in that there are users and DTS packages
> that are saved in the old MASTER and MSDB databases, and
> when I restore them from old backups, the following
> happens.
> 1) I cannot seem to recover the DTS packages.
> 2) The collation settings for these two databases revert
> to the previous setting.
> Any help please or is there a fool proof method of doing
> this.
> Cheers
> Paulsql