Thursday, February 16, 2012

Change registry keys regarding to SQL and Moving databases

Platform: Window2003 ent Failover Clustering SQL Server 2k ent sp3a.
I need change some registry keys regarding to SQL, such as:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Do I need change on all the nodes one by one?
Previously, after non-clustered default installation, I always referenced
http://support.microsoft.com/default...b;EN-US;224071 and
http://support.microsoft.com/default...;EN-US;q240867 to Move SQL
Server databases to a new location.
However, I have new windows2003 SQL server 2k sp3a setup with external
shared storage. I need relocate databases and full text indexes. I'm not
sure which way I shall follow to moving database files or change registry
keys.
These still apply to moving Clustered databases. Wherever you move the
files to, that location must be a disk resource that the SQL Service resoure
depends on.
This may be what you are looking for.
http://support.microsoft.com/default...b;en-us;295732
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:C0C4AC62-8CDC-4B60-97D3-2DE267B8E1F2@.microsoft.com...
> Platform: Window2003 ent Failover Clustering SQL Server 2k ent sp3a.
> I need change some registry keys regarding to SQL, such as:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
> Do I need change on all the nodes one by one?
> Previously, after non-clustered default installation, I always referenced
> http://support.microsoft.com/default...b;EN-US;224071 and
> http://support.microsoft.com/default...;EN-US;q240867 to Move
SQL
> Server databases to a new location.
> However, I have new windows2003 SQL server 2k sp3a setup with external
> shared storage. I need relocate databases and full text indexes. I'm not
> sure which way I shall follow to moving database files or change registry
> keys.
|||How about Registry keys? Do I have to apply node by node?
such as, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\
"Geoff N. Hiten" wrote:

> These still apply to moving Clustered databases. Wherever you move the
> files to, that location must be a disk resource that the SQL Service resoure
> depends on.
> This may be what you are looking for.
> http://support.microsoft.com/default...b;en-us;295732
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Maggie" <Maggie@.discussions.microsoft.com> wrote in message
> news:C0C4AC62-8CDC-4B60-97D3-2DE267B8E1F2@.microsoft.com...
> SQL
>
>
|||The keys are cluster-specific, not node specific. Look at:
http://support.microsoft.com/default...b;en-us;810056
and
http://support.microsoft.com/default...b;en-us;812666
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:1E721AFA-BA4F-4C38-B514-8CF57EEEC119@.microsoft.com...[vbcol=seagreen]
> How about Registry keys? Do I have to apply node by node?
> such as, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\
>
> "Geoff N. Hiten" wrote:
resoure[vbcol=seagreen]
referenced[vbcol=seagreen]
Move[vbcol=seagreen]
not[vbcol=seagreen]
registry[vbcol=seagreen]

No comments:

Post a Comment