RE: Can't Change Registry keys in Failover Clustering
From: Maggie (Maggie_at_discussions.microsoft.com)
Date: 12/29/04
- Next message: Geoff N. Hiten: "Re: Anti Virus Software 0n Cluster"
- Previous message: Rodney R. Fournier [MVP]: "Re: Active/Active Cluster - steps to follow."
- In reply to: Uttam Parui[MS]: "RE: Can't Change Registry keys in Failover Clustering"
- Next in thread: Uttam Parui[MS]: "RE: Can't Change Registry keys in Failover Clustering"
- Reply: Uttam Parui[MS]: "RE: Can't Change Registry keys in Failover Clustering"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Dec 2004 09:05:02 -0800
Actually, I already know these articles about moving databases around. And
also I always applied these procedures when each time I built new SQL Server.
However, There are not appliable to move default BACKUP, FTDATA ,JOBS and
REPLDATA folders to other disk drives instead of default E:\data\mssql\ on
failover clustering, such as,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\
Backup from E:\data\mssql\backup to F:\backup
FullTextDefaultPath from E:\DATA\MSSQL\FTDATA to E:\FTDATA
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Replication\WorkingDirectory E:\DATA\MSSQL\REPLDATA to R:\REPLDATA
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
SQLDataRoot from E:\DATA\MSSQL to E:\DATA
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent
WorkingDirectory from E:\DATA\MSSQL\JOBS to J:\JOBS
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0 for applications, gathering
manger, indexer
We do not want to point Backup, jobs, replication and FTDATA to same disk
drives. We need spread out files across the physical drives in order to
allocate resources efficiently. That's best way to implement enterprise
level database servers.
Oracle provide OFA(Optimal Flexible Architecture) to allow us to implement
very large database as part of software without additonal support call.
Microsoft should do the same feature if you have a big vision to support
enterprise databases.
Thanks.
"Uttam Parui[MS]" wrote:
> Maggie,
>
> Even though you can change the registry entries for a regular SQL Server instance, it is not the recommended/supported method (infact it is the worst case scenario and done only with the assistance of a SQL Server
> support engineer). SQL Server clustered instances are slightly different and the registry entries are replicated to all cluster nodes and are stored in the quorum. It is not supported to change the registry. That does not
> mean one cannot change the registry keys for clustered SQL instances but then what is the guarantee that something may not break. So why go the unsupported path. Not worth it for a production server.
>
> But this doesn't mean that one cannot change the location of the data files, log files, backups etc to other shared disk on the cluster. Supported steps that could be used on regular instances can still be used on
> clustered SQL Server. For example, to move the log files on a seperate drive, one could used attach/detach method or Restore with Move.
>
> KB "http://support.microsoft.com/?kbid=314546" has some ideas and links to related articles that you may find helpful.
>
> You can also open up a case with Microsoft Customer Support Services for additional support. Call Support Customer Care: 1-800-936-3500 (U.S. and Canada Only)
>
> Best Regards,
>
> Uttam Parui
> Microsoft Corporation
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
>
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
>
- Next message: Geoff N. Hiten: "Re: Anti Virus Software 0n Cluster"
- Previous message: Rodney R. Fournier [MVP]: "Re: Active/Active Cluster - steps to follow."
- In reply to: Uttam Parui[MS]: "RE: Can't Change Registry keys in Failover Clustering"
- Next in thread: Uttam Parui[MS]: "RE: Can't Change Registry keys in Failover Clustering"
- Reply: Uttam Parui[MS]: "RE: Can't Change Registry keys in Failover Clustering"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
