Tuesday, March 27, 2012

Adding a new node to a SQL server cluster

I need to add a second node to a SQL Server Cluster.
What i have to do?
I have join the second node using Cluster Administrator.
I don't see any resource..
I need to manually recreate disks resources in Cluster Administrator?
I need to reinstall SQL Server?
Thanks.
Follow the instructions in BOL. Look up 'Maintaining a Failover Cluster'.
You will need to re-run the SQL installer, but if you follow the steps
correctly, all it will do is bring in the new node. Don't forget to reapply
any service packs and hotfixes after the base install.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"SP" <spupilli@.infinito.it> wrote in message
news:eGBS4kUeEHA.2352@.TK2MSFTNGP09.phx.gbl...
> I need to add a second node to a SQL Server Cluster.
> What i have to do?
> I have join the second node using Cluster Administrator.
> I don't see any resource..
> I need to manually recreate disks resources in Cluster Administrator?
> I need to reinstall SQL Server?
> Thanks.
>
|||Hi
What version of Windows and SQL are you running on?
How is your SAN configured?
..
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SP" <spupilli@.infinito.it> wrote in message
news:eGBS4kUeEHA.2352@.TK2MSFTNGP09.phx.gbl...
> I need to add a second node to a SQL Server Cluster.
> What i have to do?
> I have join the second node using Cluster Administrator.
> I don't see any resource..
> I need to manually recreate disks resources in Cluster Administrator?
> I need to reinstall SQL Server?
> Thanks.
>
|||I'using VMWare Workstation 4.5 to test thesolution. I'll make the real
cluster the next week.
I'm using SQL Server 2000 Ent. Edition and Windows Server 2003 Ent. Edition.
Thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ha scritto nel messaggio
news:u1OSlzWeEHA.1604@.TK2MSFTNGP11.phx.gbl...
> Hi
> What version of Windows and SQL are you running on?
> How is your SAN configured?
> .
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "SP" <spupilli@.infinito.it> wrote in message
> news:eGBS4kUeEHA.2352@.TK2MSFTNGP09.phx.gbl...
>
|||Here is how you add a new node [As per SQL Server BOL topic "How to add nodes to an existing virtual server (Setup)"]
On the Welcome screen of the Microsoft SQL Server Installation Wizard, click Next.
On the Computer Name screen, click Virtual Server and specify the virtual server to which you want to add a node. Click Next.
On the Installation Selection screen, click Advanced options. Click Next.
On the Advanced Options screen, click Maintain a virtual server for failover clustering. Click Next.
On the Failover Clustering screen, click Next.
You do not need to enter an IP address.
On the Cluster Management screen, select the node and click Add.
If the node is listed as unavailable, you must modify the disk resources in the cluster group of the virtual server so the disk is available for the node you want to add to the
Microsoft SQL Server configuration. Click Next.
On the Remote Information screen, enter login credentials for the remote cluster node that has administrator privileges on the remote node of the cluster. Click Next.
On the Setup Complete screen, click Finish.
After this you will need to reapply any SQL Server service packs, security patches/hotfixes that you had applied to the virtual sql instance.
HTH,
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
|||How did you set it up in VMWare? I want to test a node active/passive
Windows 2003 cluster with SQL 2000. Do you know any good guides for doing
this? I am new to clusters :/
Best regards
Niklas E
"SP" <spupilli@.infinito.it> wrote in message
news:%23$kxl6WeEHA.3428@.TK2MSFTNGP11.phx.gbl...
> I'using VMWare Workstation 4.5 to test thesolution. I'll make the real
> cluster the next week.
> I'm using SQL Server 2000 Ent. Edition and Windows Server 2003 Ent.
> Edition.
> Thanks.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ha scritto nel messaggio
> news:u1OSlzWeEHA.1604@.TK2MSFTNGP11.phx.gbl...
>
|||The VMWARE web site explains setting up a cluster in a box. The idea is to
create two virtual computers and a shared virtual drives.
http://www.vmware.com/support/gsx25/...erbox_gsx.html
"VMware GSX Server 2.5.2"
Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment