We help IT Professionals succeed at work.

Questions about mirriring, replication, clustering...between Visual servers

I have one server divided into two MS Windows 2008 separate visual servers. Both visual servers have MSSQL 2008 R2 installed and both are 64 bit OS. I want to know if I can do replication, mirroring, clustering fail-over, log shipping setup between two VM?
Comment
Watch Question

Author

Commented:
I also want to know if replication, mirroring, clustering fail-over, log shipping setup must be between two separate machines, not VM.
Commented:
If they are 2 separate distinct virtual machines you can absolutely replicate to them.

As for clustering, I would make sure that these VMs are running on different hardware etc inside your VM cluster.

I assume you are clustering SQL2008

Author

Commented:
How about mirroring, log shipping in two VMs?

For clustering,

if the VMs are running on the same hardware inside my VM cluster? do we still do clustering?
if the VMs are running on the different hardware inside my VM cluster? do we still do clustering?

Yes, we will use clustering SQL 2008

Commented:
IMO you dont need clustering, your VM stuff is all clustered. UNLESS....

If your going over 4 processors and say 16+ Gigs of ram. (while you can go higher in ram its the processor use that will limit you) Unless your running something higher than advanced VMware. (I belive its enterprise Plus licensing on the VMware side to assign more than 4 vCPUs)

If your windows install or SQL install goes sideways you need to be able to recover.


I just move SQL 2008 server over to our VM and am having some issues. But I still think that its a software issue not a VM\windows\SQL issue.
We run 3 major SQL 2008 instances in our cluster.

Author

Commented:
One more question,

Using VMs on same machine to do clustering, log shipping, replication is better or using complete separate two machines to do these is better?

Author

Commented:
useful info

Explore More ContentExplore courses, solutions, and other research materials related to this topic.