Re: Quickest way to change Collation of Master DB?
From: Fred Morrison (fmorrison_at_erols.com)
Date: 07/11/04
- Next message: Stu: "Re: SQL2k standard on Win2k3 Web Ed. Wont install"
- Previous message: Andrew J. Kelly: "Re: New Server RAID setup"
- In reply to: Hari Prasad: "Re: Quickest way to change Collation of Master DB?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 11 Jul 2004 10:47:21 -0400
Your advice doesn't work unless you also take the steps outlined in KB
273572.
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%236COWqjZEHA.644@tk2msftngp13.phx.gbl...
> Hi,
>
> From Microsoft KB.
>
> Change the collation of the master database
> If you want to change the collation of the master database, you must
rebuild
> the master database. When you rebuild the master database, you essentially
> create a new master database. Therefore, consider the following items
before
> you rebuild the master database:
> a.. Make sure to make a valid backup of the current master database.
When
> you rebuild the master database, the msdb database and the model database
> are also re-created. Therefore, you must back up the msdb database and the
> model database before you rebuild the master database. The msdb database
is
> the system database that is used to store your SQL Server jobs, alerts,
> operators, and DTS packages. The model database is the template database
> that is used when you create a new database.
> b.. Because rebuilding the master database creates a new master
database,
> you must re-enter the existing login information after you rebuild the
> master database. Therefore, you must export the login information before
you
> rebuild the master database. After you re-create the master database,
import
> the login information. For additional information about how to export
login
> information, click the following article number to view the article in the
> Microsoft Knowledge Base:
> http://support.microsoft.com/?kbid=325335#7
>
> Thanks
> Hari
> MCDBA
>
> "Fred Morrison" <anonymous@discussions.microsoft.com> wrote in message
> news:2a2a801c465f0$807ba600$a401280a@phx.gbl...
> > I need to change the collation of the Master database on
> > my (local) server to Latin1_General_CP1_CI_AS.
> >
> > What's the quickest, painless way to do that?
>
>
- Next message: Stu: "Re: SQL2k standard on Win2k3 Web Ed. Wont install"
- Previous message: Andrew J. Kelly: "Re: New Server RAID setup"
- In reply to: Hari Prasad: "Re: Quickest way to change Collation of Master DB?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
