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.
Showing posts with label doi. Show all posts
Showing posts with label doi. Show all posts
Tuesday, March 27, 2012
Tuesday, March 20, 2012
'Addding' Column In View
Hi! Here is what I need to do:
I have 2 tables; the first called "IDs" and the second called "Test".
This 'Test' doesn't have an identity field, and I need to have one to
do some filtering, but for burocracy I can't simply add another column
to the table. So, as
as it is, I had to create another table
called 'IDs' with only 1 field called 'ID' filled with autogenerated
numbers from 1 to 99999999^9999 :D. Then, the thing that I can't do is
to "append" this table to the "Test".
When I do, for example:
<select IDs.id, Test.Name from IDs, test>, what I get is something
like:
id name
--
----
1 ABC
2 ABC
3 ABC
4 ABC
1 DEF
2 DEF
3 DEF
4 DEF
1 GHI
2 GHI
3 GHI
4 GHI
1 JKM
2 JKM
3 JKM
4 JKM
Notice the repetition of the values...
I would need it to be like:
id name
--
----
1 ABC
2 ABC
3 ABC
4 ABC
So... is there something I can do to get this? And also, what would
happen if one of the tables had more registries than the other? Would
it work?
Very very thanks in advance;
Bye.See if this helps:
How to dynamically number rows in a SELECT Statement
http://support.microsoft.com/defaul...kb;en-us;186133
AMB
"Dan_Aykroyd" wrote:
> Hi! Here is what I need to do:
> I have 2 tables; the first called "IDs" and the second called "Test".
> This 'Test' doesn't have an identity field, and I need to have one to
> do some filtering, but for burocracy I can't simply add another column
> to the table. So, as as it is, I had to create another table
> called 'IDs' with only 1 field called 'ID' filled with autogenerated
> numbers from 1 to 99999999^9999 :D. Then, the thing that I can't do is
> to "append" this table to the "Test".
> When I do, for example:
> <select IDs.id, Test.Name from IDs, test>, what I get is something
> like:
> id name
> --
> ----
> 1 ABC
> 2 ABC
> 3 ABC
> 4 ABC
> 1 DEF
> 2 DEF
> 3 DEF
> 4 DEF
> 1 GHI
> 2 GHI
> 3 GHI
> 4 GHI
> 1 JKM
> 2 JKM
> 3 JKM
> 4 JKM
> Notice the repetition of the values...
> I would need it to be like:
> id name
> --
> ----
> 1 ABC
> 2 ABC
> 3 ABC
> 4 ABC
> So... is there something I can do to get this? And also, what would
> happen if one of the tables had more registries than the other? Would
> it work?
> Very very thanks in advance;
> Bye.
>|||SQL2005 will have 'rownumber', which will let you do it really easily.
But for the time being, you will have to do it the nasty way.|||Wow... it wasn't as easy as I thought! :)
I thought that what I needed to do would be easy, because it
requires... "no processing"; I mean, no combination of rows, no
relations, no linking, etc etc; it's just adding a column to a view in
the way it's stored in the table...
Thanks very much Alejandro; I'm gonna read it now!
And if there's an easier way... I'd be glad to hear it ;)sql
I have 2 tables; the first called "IDs" and the second called "Test".
This 'Test' doesn't have an identity field, and I need to have one to
do some filtering, but for burocracy I can't simply add another column
to the table. So, as
as it is, I had to create another tablecalled 'IDs' with only 1 field called 'ID' filled with autogenerated
numbers from 1 to 99999999^9999 :D. Then, the thing that I can't do is
to "append" this table to the "Test".
When I do, for example:
<select IDs.id, Test.Name from IDs, test>, what I get is something
like:
id name
--
----
1 ABC
2 ABC
3 ABC
4 ABC
1 DEF
2 DEF
3 DEF
4 DEF
1 GHI
2 GHI
3 GHI
4 GHI
1 JKM
2 JKM
3 JKM
4 JKM
Notice the repetition of the values...
I would need it to be like:
id name
--
----
1 ABC
2 ABC
3 ABC
4 ABC
So... is there something I can do to get this? And also, what would
happen if one of the tables had more registries than the other? Would
it work?
Very very thanks in advance;
Bye.See if this helps:
How to dynamically number rows in a SELECT Statement
http://support.microsoft.com/defaul...kb;en-us;186133
AMB
"Dan_Aykroyd" wrote:
> Hi! Here is what I need to do:
> I have 2 tables; the first called "IDs" and the second called "Test".
> This 'Test' doesn't have an identity field, and I need to have one to
> do some filtering, but for burocracy I can't simply add another column
> to the table. So, as
as it is, I had to create another table> called 'IDs' with only 1 field called 'ID' filled with autogenerated
> numbers from 1 to 99999999^9999 :D. Then, the thing that I can't do is
> to "append" this table to the "Test".
> When I do, for example:
> <select IDs.id, Test.Name from IDs, test>, what I get is something
> like:
> id name
> --
> ----
> 1 ABC
> 2 ABC
> 3 ABC
> 4 ABC
> 1 DEF
> 2 DEF
> 3 DEF
> 4 DEF
> 1 GHI
> 2 GHI
> 3 GHI
> 4 GHI
> 1 JKM
> 2 JKM
> 3 JKM
> 4 JKM
> Notice the repetition of the values...
> I would need it to be like:
> id name
> --
> ----
> 1 ABC
> 2 ABC
> 3 ABC
> 4 ABC
> So... is there something I can do to get this? And also, what would
> happen if one of the tables had more registries than the other? Would
> it work?
> Very very thanks in advance;
> Bye.
>|||SQL2005 will have 'rownumber', which will let you do it really easily.
But for the time being, you will have to do it the nasty way.|||Wow... it wasn't as easy as I thought! :)
I thought that what I needed to do would be easy, because it
requires... "no processing"; I mean, no combination of rows, no
relations, no linking, etc etc; it's just adding a column to a view in
the way it's stored in the table...
Thanks very much Alejandro; I'm gonna read it now!
And if there's an easier way... I'd be glad to hear it ;)sql
Monday, February 13, 2012
Add a 3rd node to a 2 instance active/active cluster
If I add a 3rd node to an already existing 2 node active/active cluster, do
I have to take the other 2 instances offline as I configure the 3rd node?
I have never configured a cluster before, but I am under the assumption that
when you build a cluster, each nodes should be able to map to the shared
resource drives and due to that, I would have to take the other instances
offline.
Thanks
Not that it matters, but SQL2K or 2K5? I've just been doing this the
past couple of days and have some tips for you if 2K...
But to answer your question - you shouldn't have to take them offline.
On Feb 4, 12:24 pm, "Hassan" <has...@.hotmail.com> wrote:
> If I add a 3rd node to an already existing 2 node active/active cluster, do
> I have to take the other 2 instances offline as I configure the 3rd node?
> I have never configured a cluster before, but I am under the assumption that
> when you build a cluster, each nodes should be able to map to the shared
> resource drives and due to that, I would have to take the other instances
> offline.
> Thanks
|||Im all ears for tips.. so shoot away.. Can your tips not apply for 2K5 ?
<unc27932@.yahoo.com> wrote in message
news:1170779511.734049.110890@.s48g2000cws.googlegr oups.com...
> Not that it matters, but SQL2K or 2K5? I've just been doing this the
> past couple of days and have some tips for you if 2K...
> But to answer your question - you shouldn't have to take them offline.
> On Feb 4, 12:24 pm, "Hassan" <has...@.hotmail.com> wrote:
>
|||It will take the instances offline, although SS2K5 minimizes this much more.
A bigger issue is that before the new node will be able to host the
resources, you will need to patch it to the same build level as the other
two nodes.
The add a node step only lays out the RTM binaries.
Sincerely,
Anthony Thomas
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23kRF9AmSHHA.1364@.TK2MSFTNGP06.phx.gbl...[vbcol=seagreen]
> Im all ears for tips.. so shoot away.. Can your tips not apply for 2K5 ?
> <unc27932@.yahoo.com> wrote in message
> news:1170779511.734049.110890@.s48g2000cws.googlegr oups.com...
cluster,[vbcol=seagreen]
node?[vbcol=seagreen]
shared[vbcol=seagreen]
instances
>
I have to take the other 2 instances offline as I configure the 3rd node?
I have never configured a cluster before, but I am under the assumption that
when you build a cluster, each nodes should be able to map to the shared
resource drives and due to that, I would have to take the other instances
offline.
Thanks
Not that it matters, but SQL2K or 2K5? I've just been doing this the
past couple of days and have some tips for you if 2K...
But to answer your question - you shouldn't have to take them offline.
On Feb 4, 12:24 pm, "Hassan" <has...@.hotmail.com> wrote:
> If I add a 3rd node to an already existing 2 node active/active cluster, do
> I have to take the other 2 instances offline as I configure the 3rd node?
> I have never configured a cluster before, but I am under the assumption that
> when you build a cluster, each nodes should be able to map to the shared
> resource drives and due to that, I would have to take the other instances
> offline.
> Thanks
|||Im all ears for tips.. so shoot away.. Can your tips not apply for 2K5 ?
<unc27932@.yahoo.com> wrote in message
news:1170779511.734049.110890@.s48g2000cws.googlegr oups.com...
> Not that it matters, but SQL2K or 2K5? I've just been doing this the
> past couple of days and have some tips for you if 2K...
> But to answer your question - you shouldn't have to take them offline.
> On Feb 4, 12:24 pm, "Hassan" <has...@.hotmail.com> wrote:
>
|||It will take the instances offline, although SS2K5 minimizes this much more.
A bigger issue is that before the new node will be able to host the
resources, you will need to patch it to the same build level as the other
two nodes.
The add a node step only lays out the RTM binaries.
Sincerely,
Anthony Thomas
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23kRF9AmSHHA.1364@.TK2MSFTNGP06.phx.gbl...[vbcol=seagreen]
> Im all ears for tips.. so shoot away.. Can your tips not apply for 2K5 ?
> <unc27932@.yahoo.com> wrote in message
> news:1170779511.734049.110890@.s48g2000cws.googlegr oups.com...
cluster,[vbcol=seagreen]
node?[vbcol=seagreen]
shared[vbcol=seagreen]
instances
>
Subscribe to:
Posts (Atom)