Re: Quickest way to change Collation of Master DB?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/10/04

  • Next message: Justin: "Re: SQL Entp setup on Windows 2003 error" 
    Date: Sat, 10 Jul 2004 10:17:28 +0530

    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: Justin: "Re: SQL Entp setup on Windows 2003 error"

    Relevant Pages

    • Re: Quickest way to change Collation of Master DB?
      ... > If you want to change the collation of the master database, ... When you rebuild the master database, ... you must export the login information before ...
      (microsoft.public.sqlserver.setup)
    • RE: Recovering Master Database In a Active/Passive Cluster
      ... What do you mean by recover the master database? ... HOWTO: Rebuild the MASTER Database on a Virtual SQL Server 2000 Instance ...
      (microsoft.public.sqlserver.clustering)
    • Re: Master Database is corrupted.
      ... rebuild the master database using rebuildm.exe. ... SQL Server MVP ... > - When I check the logs in the SQLServer folder, ...
      (microsoft.public.sqlserver.msde)
    • Re: MSDE - Master database
      ... other option would be to rebuild the master database using the rebuildm ... utiliy. ... This option is used if u do not have any backup of the master ...
      (microsoft.public.sqlserver.msde)
    • Re: corrupt master DB
      ... rebuild the master database using rebuildm.exe. ... > We had disk failures and SQL Server won't come back up ... Is there any recovery ...
      (microsoft.public.sqlserver.server)