 |
|
|
|
Next: Single node cluster with multiple instances but a..
|
| Author |
Message |
External
Since: Sep 24, 2004
Posts: 66
|
(Msg. 1) Posted: Mon Jan 14, 2008 8:49 am
Post subject: 2000 Cluster
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
|
|
|
We're going to have to move data to a new 2000 SP4 server. We want to
cluster it down the road, probably Q4 of 2008, but can't do it right now. So
here's my question:
1. What do I have to do to this new server to make sure it can be clustered
about six months down the road?
2. I heard that when I do the install I have to do a named instance even if
that's the only instance on this machine? Is that true and what do they mean
by that?
Any advice would be much appreciated... |
|
| Back to top |
|
 | |
External
Since: Jul 12, 2006
Posts: 30
|
(Msg. 2) Posted: Mon Jan 14, 2008 9:55 am
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"CLM" wrote in message
> We're going to have to move data to a new 2000 SP4 server. We want to
> cluster it down the road, probably Q4 of 2008, but can't do it right now.
> So
> here's my question:
>
> 1. What do I have to do to this new server to make sure it can be
> clustered
> about six months down the road?
You don't. You must have your cluster built before installing SQL, you can't
do it the other way around.
> 2. I heard that when I do the install I have to do a named instance even
> if
> that's the only instance on this machine? Is that true and what do they
> mean
> by that?
Read Books Online regarding named instances vs. default instance. It is
highly recommended that you use named instances only on clusters.
--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Mar 10- 13 in Denver
May 12-15 in New York |
|
| Back to top |
|
| |
External
Since: Oct 25, 2006
Posts: 84
|
(Msg. 3) Posted: Mon Jan 14, 2008 11:15 am
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
You can't upgrade from a default instance to a clustered instance later?
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Russ Kaufmann [MVP]" wrote in message
> "CLM" wrote in message
>
>> We're going to have to move data to a new 2000 SP4 server. We want to
>> cluster it down the road, probably Q4 of 2008, but can't do it right now.
>> So
>> here's my question:
>>
>> 1. What do I have to do to this new server to make sure it can be
>> clustered
>> about six months down the road?
>
> You don't. You must have your cluster built before installing SQL, you
> can't do it the other way around.
>
>> 2. I heard that when I do the install I have to do a named instance even
>> if
>> that's the only instance on this machine? Is that true and what do they
>> mean
>> by that?
>
> Read Books Online regarding named instances vs. default instance. It is
> highly recommended that you use named instances only on clusters.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
> The next ClusterHelp classes are:
> Mar 10- 13 in Denver
> May 12-15 in New York
> >> Stay informed about: 2000 Cluster |
|
| Back to top |
|
| |
External
Since: Jul 12, 2006
Posts: 30
|
(Msg. 4) Posted: Mon Jan 14, 2008 12:16 pm
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Oct 25, 2006
Posts: 84
|
(Msg. 5) Posted: Mon Jan 14, 2008 1:30 pm
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Books Online topic:
How to upgrade from a default instance to a default clustered instance of
SQL Server 2000 (Setup)
Is this misnamed, or am I missing something here? I promise I'm not trying
to be painful  Sometimes it just works out that way...
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Russ Kaufmann [MVP]" wrote in message
> "Kevin3NF" wrote in message
>
>> You can't upgrade from a default instance to a clustered instance later?
>
> You can migrate, but you can't upgrade.
>
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
> The next ClusterHelp classes are:
> Mar 10- 13 in Denver
> May 12-15 in New York
> >> Stay informed about: 2000 Cluster |
|
| Back to top |
|
| |
External
Since: Jul 12, 2006
Posts: 30
|
(Msg. 6) Posted: Mon Jan 14, 2008 1:30 pm
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Kevin3NF" wrote in message
> Books Online topic:
> How to upgrade from a default instance to a default clustered instance of
> SQL Server 2000 (Setup)
> Is this misnamed, or am I missing something here? I promise I'm not
> trying to be painful Sometimes it just works out that way...
You are missing something. See Geoff's post right below.
--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Mar 10- 13 in Denver
May 12-15 in New York >> Stay informed about: 2000 Cluster |
|
| Back to top |
|
| |
External
Since: Oct 25, 2006
Posts: 84
|
(Msg. 7) Posted: Mon Jan 14, 2008 2:09 pm
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Geoff's post refers to SQL 2005.
CLM's original request only specifies:
>>We're going to have to move data to a new 2000 SP4 server.<<
with no mention of 2005...
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Russ Kaufmann [MVP]" wrote in message
>
> "Kevin3NF" wrote in message
>
>> Books Online topic:
>> How to upgrade from a default instance to a default clustered instance of
>> SQL Server 2000 (Setup)
>> Is this misnamed, or am I missing something here? I promise I'm not
>> trying to be painful Sometimes it just works out that way...
>
> You are missing something. See Geoff's post right below.
>
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
> The next ClusterHelp classes are:
> Mar 10- 13 in Denver
> May 12-15 in New York
> >> Stay informed about: 2000 Cluster |
|
| Back to top |
|
| |
External
Since: Jul 12, 2006
Posts: 30
|
(Msg. 8) Posted: Mon Jan 14, 2008 2:09 pm
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Kevin3NF" wrote in message
> Geoff's post refers to SQL 2005.
>
> CLM's original request only specifies:
>>>We're going to have to move data to a new 2000 SP4 server.<<
>
> with no mention of 2005...
No difference. You have to build the cluster first.
--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Mar 10- 13 in Denver
May 12-15 in New York >> Stay informed about: 2000 Cluster |
|
| Back to top |
|
| |
External
Since: Oct 25, 2006
Posts: 84
|
(Msg. 9) Posted: Mon Jan 14, 2008 2:39 pm
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Apples to green apples
yes, the Windows cluster has to be built adding shared storage and
(hopefully) a 2nd node.
But...
Take the existing SQL Server, make it part of that Windows cluster, stop the
services, move the databases to the Shared drive(s) and run the "upgrade"
from the Installation wizard. All this is really doing is copying binaries
to the new node(s), and creating the various registry entries that point to
all the right places.
I'll stop now just trying to be clear to CLM that the new server he is
building can be bumped to a Clustered SQL Server.
Have a great day!
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Russ Kaufmann [MVP]" wrote in message
> "Kevin3NF" wrote in message
>
>> Geoff's post refers to SQL 2005.
>>
>> CLM's original request only specifies:
>>>>We're going to have to move data to a new 2000 SP4 server.<<
>>
>> with no mention of 2005...
>
> No difference. You have to build the cluster first.
>
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
> The next ClusterHelp classes are:
> Mar 10- 13 in Denver
> May 12-15 in New York
> >> Stay informed about: 2000 Cluster |
|
| Back to top |
|
| |
External
Since: Feb 23, 2005
Posts: 443
|
(Msg. 10) Posted: Mon Jan 14, 2008 3:52 pm
Post subject: Re: 2000 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Technically, upgrading a stand-alone installation to a clustered
installation is possible in SQL 2000. It is also highly NOT recommended.
There was a good reason the feature was pulled from SQL 2005. I suspect it
was the high failure rate amongst those that attempted it. Those who could
pull it off knew better than to try.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Kevin3NF" wrote in message
> Apples to green apples
>
> yes, the Windows cluster has to be built adding shared storage and
> (hopefully) a 2nd node.
>
> But...
>
> Take the existing SQL Server, make it part of that Windows cluster, stop
> the services, move the databases to the Shared drive(s) and run the
> "upgrade" from the Installation wizard. All this is really doing is
> copying binaries to the new node(s), and creating the various registry
> entries that point to all the right places.
>
> I'll stop now just trying to be clear to CLM that the new server he is
> building can be bumped to a Clustered SQL Server.
>
> Have a great day!
>
> --
>
> Kevin3NF
> SQL Server dude
>
> You want fries with that?
> http://kevin3nf.blogspot.com/
>
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>
>
> "Russ Kaufmann [MVP]" wrote in message
>
>> "Kevin3NF" wrote in message
>>
>>> Geoff's post refers to SQL 2005.
>>>
>>> CLM's original request only specifies:
>>>>>We're going to have to move data to a new 2000 SP4 server.<<
>>>
>>> with no mention of 2005...
>>
>> No difference. You have to build the cluster first.
>>
>>
>> --
>> Russ Kaufmann
>> MVP - Windows Server - Clustering
>> ClusterHelp.com, a Microsoft Certified Gold Partner
>> Web http://www.clusterhelp.com
>> Blog http://msmvps.com/clusterhelp
>>
>> The next ClusterHelp classes are:
>> Mar 10- 13 in Denver
>> May 12-15 in New York
>>
>
> >> Stay informed about: 2000 Cluster |
|
| Back to top |
|
| |
| Related Topics: | Moving from cluster to un-clustered - SQL 2000 - From what I'm given to understand, a re-install of SQL Server is required to return to an un-clustered mode. We do not plan any other changes: o/s will remain the same as will all current databases. The server name will be changed to match the current...
Memory configuration for sql server 2000 active/passive cl.. - Dear All, We are installating an acive/passive sql server 2000 cluster. One of my friend recommended to configure the max server memory as total server memory - 256. When I asked him why, he said it will prevent SQL Serer 2000 from using all the..
TCP/IP Binding failure in SQL Server 2000 cluster - Dear All, Microsoft recommends the following resolution to fix the TCP/IP binding failures. http://support.microsoft.com/kb/307197/en-us The article refers to a registry key TcpAbortiveClose. Can I know what is the use is TcpAbortiveClose and what is...
Cluster problem sql server 2000 active/passive is running .. - Hello, Today, during work, suddenly my sql server was stopped, cluster started failover. Did not switch node but started sql on the same active machine. After that I got message that on passive machine also sql server service is running :( I tried to..
SQL 2000 cluster in-place upgrade to SQL 2005 - I have a 2 node (Active/Passive) SQL cluster running on 2 2003 nodes. I want to upgrade this cluster to a SQL 2005 cluster. I know that I can do a side by side migration and install a new instance of SQL cluster and then migrate the DATA - but I.. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
