Re: Active/Active Cluster - steps to follow.
From: Rodney R. Fournier [MVP] (rod_at_die.spam.die.nw-america.com)
Date: 12/29/04
- Next message: Maggie: "RE: Can't Change Registry keys in Failover Clustering"
- Previous message: Uttam Parui[MS]: "Re: Anti Virus Software 0n Cluster"
- In reply to: Sezgin Rafed: "Re: Active/Active Cluster - steps to follow."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Dec 2004 11:02:59 -0600
Answers inline below...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Sezgin Rafed" <anonymous@anonymous.com> wrote in message
news:uEAc%238Z7EHA.1400@TK2MSFTNGP11.phx.gbl...
> Current setup:
>
>
>
> Windows 2003 Server Cluster - Cluster1 .
> 2 nodes - SQLBox1 and SQLBox2.
> 1 Virtual SQL Server - VirtualServer1.
> 2 shared drives on SAN - R: for SQL Server databases and Q: for the quorum
> drive.
>
>
>
> We consider setting up another virtual SQL Server - Virtual Server2.
> Below are the steps, which I consider following. My knowledge in this
> field
> is very limited, so please correct whereever needed.
>
>
>
>
>
> 1.Make SQLBox1 the active node(VirtualServer1). Shut down SQLBox2(is this
> necessary ?).
>
>
You don't need or want to shutdown the 2nd box.
>
> 2.Get new shared drive from SAN - drive T:. HP does this for our company -
> I think they use zoning. Given they are both online, will the new shared
> drive be accessible simultaneously from both servers?.
>
>
Yes, each should see them in Device manager, disks.
>
> 3.Connect to Cluster1 and create a new group - Reports. Add the new T:
> drive
> as new Resource(Physical Disk) - in Reports group.Owner will be SQLBox1.
>
>
You need to format the new drive from its controlling node. Assign the drive
letter T: it. The rest is fine.
>
> 4.Turn on SQLBox2(if it was necessary to turn it off). Connect to Cluster1
> and Move the Reports group to SQLBox2.
>
>
Leave the machine on. Just move the group.
>
> 5.Run SQL Server Setup from SQLBox2 and create a new Virtual SQL Server -
> VirtualServer2 ,named SQL instance - ReportServer. Database files on drive
> T:
>
> The new SQL Server will be accessed as VirtualServer2\ ReportServer.
>
>
Works for me, though I like to have more drives. One for Databases, One for
Logs, one for MSDTC is you use it. In this case, you would need more drives
defined on the SAN.
>
> 6. SQL Server Setup will create new Resorces -IP Address,Network Name,SQL
> Server, SQL Agent(will it also create another SQL Server Fulltext ?). Add
> the new resources to the Reports group.
>
Yes.
>
>
> 7.Create a new Dependency for the new SQL Server Resource - to depend on
> drive T:
>
>
The install should do that for you.
>
- Next message: Maggie: "RE: Can't Change Registry keys in Failover Clustering"
- Previous message: Uttam Parui[MS]: "Re: Anti Virus Software 0n Cluster"
- In reply to: Sezgin Rafed: "Re: Active/Active Cluster - steps to follow."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
