Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2008-02-27 : 07:52:03
|
| Hi,I've landed a new job as a full time DBA and before starting the 1st of April I need to brush up some skills regarding high availability. My plan is to create two vmware-images running Win2k3 Server and then install two SQL Server 2005 Enterprise Edition instances on each of the two images so I would have a total of 2 servers and 4 instances of sql server. Do you guys think this would work and will it be sufficient to create clusters, replication, log-shipping, mirroring and all that fancy stuff? To be honest I've never worked much with any of it so I'm sort of braking new ground for myself here...any alternate solutions are of course also welcome!--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE Price IS NULL" |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-27 : 09:41:47
|
| Have you verified that VMWare supports clusters?CODO ERGO SUM |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-02-27 : 10:09:40
|
| Well, we have a few clustered vmware-servers at my current job but I don't think it's officially supported...I haven't set them up myself so I really don't know how it works.--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4" |
|
|
|
DennisMenace
Starting Member
4 Posts |
Posted - 2008-02-28 : 01:57:05
|
| Yes this can be done.I've just gone through the process of doing the same thing.We actually had 3 VM images, one for each of the two node cluster and one Domain Controler (installing SQL on a cluster requires domain accounts).I actually got the VM's with the cluster already built I then went through the process of adding extra virtual SCSI drives and setting up the cluster groups, then finally installing three instances of SQL.You can use this link for some info on setting up clustering in VMWarehttp://download3.vmware.com/vmworld/2006/dvt4696.pdfYou would also need a further image to try out log shipping (or two if you need a monitor server)I'm still to new to know about either the replication or the mirroring. |
|
|
|
|
|
|
|
|
High availability setup for practising purposes