SQL 2000 stand-alone

SQL 2000 stand-alone

Post by » Thu, 15 Feb 2007 08:40:52

I have SQL 2000 stand-alone that I will need to move to a new cluster
hardware and upgrade to SQL 2005 without impacting replecation.
Can I do that and If so how ?
Thanks in advance!

SQL 2000 stand-alone

Post by Rodney R. » Thu, 15 Feb 2007 08:44:10

Might be easy to buy new machines and migrate to them. You have to install
clustering before SQL.


Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.yqcomputer.com/ - Clustering Website
http://www.yqcomputer.com/ - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


SQL 2000 stand-alone

Post by » Thu, 15 Feb 2007 09:01:02

I have new Hardware for the Server, My question is since my production Box
is SQL 2000 a stand-alone with replication running, can I migrate to the New
hardware upgrade to SQL 2005 and be able to build Active/Passive cluster
without impacting replication.

"Rodney R. Fournier [MVP]" < XXXX@XXXXX.COM > wrote in

SQL 2000 stand-alone

Post by Anthony Th » Thu, 15 Feb 2007 22:40:24

Please do not multi-post. I've already responded to your previous post.

In short, no. You cannot migrate without any impact. However, you should
be able to with minimal impact.

Anthony Thomas