dbTalk Databases Forums  

2000 Cluster

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering 2000 Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss 2000 Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
Page 5 of 11 < 1 2 3 4 5 6 7 8 9 10 11 >
 
Thread Tools Display Modes
  #41  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:17 PM





From SQL BOL (Emphasis added):

To upgrade an instance of SQL Server to a SQL Server 2005 failover cluster, the instance being upgraded must be a SQL Server 2000 or SQL Server 2005 failover cluster. Direct upgrade of a SQL Server 7.0 failover cluster instance to a SQL Server 2005 failover cluster instance is not supported. To upgrade a stand-alone instance of SQL Server or a SQL Server 7.0 failover cluster instance to a SQL Server 2005 failover cluster, install a new SQL Server 2005 failover cluster. Then, migrate user databases from the stand-alone instance by using detach/attach, or by using the Copy Database Wizard. For more information about database migration, see Using the Copy Database Wizard.

Link to the page is here:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/ea8b7d66-e5a1-402f-9928-8f7310e84f5c.htm


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




"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote

Quote:
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]" <russ (AT) clusterhelp (DOT) com> wrote in message
news:76B2845F-3838-491F-B542-599BDF0043EE (AT) microsoft (DOT) com...
"CLM" <CLM (AT) discussions (DOT) microsoft.com> wrote in message
news:C27E3C26-DE89-4033-BF5B-F6518D3A171A (AT) microsoft (DOT) com...
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

Reply With Quote
  #42  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM





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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #43  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #44  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #45  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #46  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #47  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #48  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #49  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
  #50  
Old   
Kevin3NF
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 01:30 PM


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]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OLXaNEtVIHA.5132 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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



Reply With Quote
Reply
Page 5 of 11 < 1 2 3 4 5 6 7 8 9 10 11 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top