Re: 3 quick Qurestions about SQL

Geoff

Again, You have come through, I plan on doing it all that way, and Thanks
again.

I will make sure that when I am asked where to place my System Databases, I
note it because the DBA's want to know exactly where it is
--
Scott A Cummins
Sr. Systems Engineer
Equity Analytics
( A division of Merrill Lynch)
14614 N. Keirland Blvd
Scottsdale, AZ 85254
480-998-3515


"Geoff N. Hiten" wrote:

Comments Inline

"Scott Cummins" <scummins@xxxxxxxxxxxxxxxxx> wrote in message
news:C508493B-E490-4B9A-855F-21359AEB4B0C@xxxxxxxxxxxxxxxx
First, Is it Necessary to create an MSDTC Group on your SQL Cluster with
its
own name, IP and resources or just a good idea, I am planning on doing it,
My
last SQL cluster did not have one But I didn't build it. I just want to be
sure.

You don't have to, but configuring MSTDC on a cluster is a good idea. A
separate group is only necessary on systems with a lot of distributed
transactions. For most clusters, putting it in the cluster group is fine.

Second, When you create a SQL Cluster and use the default instance
(MSSQLSERVER) where are the system databases physically located or placed
by
the install process.

They are placed on the designated cluster drive.

and Third, I plan on using "SHARED RESOURCES" that are currently attached
to
a single server and just move them to a new "Storage group" which contains
my
new Cluster nodes, This resources already contain all my production
databases, When i try to attach them to my new SQL Cluster, Can I expect
any
issues?, My system )master, model....etc) databases are going to be
rebuilt
and the Instance name is the same as the old one (MSSQLSERVER)

Turn off all but one node.
Present the LUNs to the new node by changing the SAN storage group.
Make sure the new node cna see the LUNs.
Give the LUNs drive letters.
Create clustered disk resources that map to the new LUNs.
Move the resources into the SQL Resource Group.
Modify the dependencies for the SQL Service to be dependent on the new disk
resources
Now you can start the service and attach the files.
If Geoff ever ends up visiting Arizona or you end up visiting Atlanta, you
buy the beer. :)

You will still need to reconcile users and logins. See
sp_change_users_login in BOL for details.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP



Thanks so much to everyone
--
Scott A Cummins
Sr. Systems Engineer
Equity Analytics
( A division of Merrill Lynch)
14614 N. Keirland Blvd
Scottsdale, AZ 85254
480-998-3515


.

Relevant Pages

  • RE: ERR VSS: Got Component: Cluster Database
    ... Ernie ... > Have you checked all the resources to make sure they list both nodes as ... > Windows NT/2000/2003 Cluster Technologies ... I'm running SQL Server clustered on a two node ...
    (microsoft.public.windows.server.clustering)
  • Re: Will failover be triggered by failure of fibrechannel HBA?
    ... Losing connectivity to the disk ... will cause that resource and all resources that depend on it to fail. ... will trigger a cluster failover. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • RE: ERR VSS: Got Component: Cluster Database
    ... Windows NT/2000/2003 Cluster Technologies ... >> Have you checked all the resources to make sure they list both nodes as ... I'm running SQL Server clustered on a two ... >>> resources on it whenever I do a windows update. ...
    (microsoft.public.windows.server.clustering)
  • Re: 3 quick Qurestions about SQL
    ... own name, IP and resources or just a good idea, I am planning on doing it, My ... last SQL cluster did not have one But I didn't build it. ... but configuring MSTDC on a cluster is a good idea. ... Present the LUNs to the new node by changing the SAN storage group. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2k to SQL 2K5 in Active Passive Cluster
    ... I usually detach the database files, take a SAN snapshot so I can revert, and then move the LUNS into the SQL 2005 group. ... Microsoft SQL Server MVP ... Install SQL 2k5 cluster instance ...
    (microsoft.public.sqlserver.clustering)
Loading