Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Activepassive to activeactive sql server 2000

 
   Database Forums (Home) -> Clustering RSS
Next:  Accounts in Mysql  
Author Message
Mike

External


Since: Mar 15, 2006
Posts: 64



(Msg. 1) Posted: Wed Feb 13, 2008 7:08 am
Post subject: Activepassive to activeactive sql server 2000
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

How do you migrate a cluster from active\passive to active\active in sql
server 2000 running Windows Server 2003 R2?

Thank you.
--
Mike

 >> Stay informed about: Activepassive to activeactive sql server 2000 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 2) Posted: Wed Feb 13, 2008 10:12 am
Post subject: Re: Activepassive to activeactive sql server 2000 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You install a second instance.

You will need new disks, new IP addresses, and a new network Name for the
new instance. In essence, it will appear and act as a second database
server.

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


"Mike" wrote in message

> How do you migrate a cluster from active\passive to active\active in sql
> server 2000 running Windows Server 2003 R2?
>
> Thank you.
> --
> Mike

 >> Stay informed about: Activepassive to activeactive sql server 2000 
Back to top
Login to vote
Russ Kaufmann [MVP]

External


Since: Jul 12, 2006
Posts: 30



(Msg. 3) Posted: Wed Feb 13, 2008 10:12 am
Post subject: Re: Activepassive to activeactive sql server 2000 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Geoff N. Hiten" wrote in message

> You install a second instance.
>
> You will need new disks, new IP addresses, and a new network Name for the
> new instance. In essence, it will appear and act as a second database
> server.

and then you put one instance on one node and the other instance on the
other node... tadaaaa, you are done


--
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: Activepassive to activeactive sql server 2000 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
ActivePassive to ActiveActive - How can we convert our SQL Server 2000 (Windows Server 2003 R2) Active\Passive cluster to Active\Active? Thank you. -- Mike

SQL Server 2000 Post SP4 Hotfixes - Build 2187 is a cummulative hotfix package. My understanding of this is that it contains all hotfixes post SP4 up to the point of the package release (basically up through build 2185). I am seeing, though, the following statement on every hotfix..

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..
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
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



[ Contact us | Terms of Service/Privacy Policy ]