jjoz
asked on
Combining 2x SQL Server 2008 standard x64 instance to provide redundant SQL Server VM
Hi All,
At the moment I'd like to combine my departmental SQL Server into one big SQL Server 2008 instances spread across two servers (for redundancy reason).
How/what is the best way to approach this ?
is it through clustering or Log shipping or VMware (hypervisor) High Availability features ?
Note: this DB server cannot go down as it is hosting the VCenter DB and also server monitoring database too.
Any suggestion and comment would be greatly appreciated.
Thanks.
At the moment I'd like to combine my departmental SQL Server into one big SQL Server 2008 instances spread across two servers (for redundancy reason).
How/what is the best way to approach this ?
is it through clustering or Log shipping or VMware (hypervisor) High Availability features ?
Note: this DB server cannot go down as it is hosting the VCenter DB and also server monitoring database too.
Any suggestion and comment would be greatly appreciated.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your reply "Fault Tolerence of VMs" --> too complex and strict requirement (not that flexible).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes that is true and as for the Fault Tolerance, I think I cannot go down to that path because I will need to configure 2vCPU and FT doesn't support it yet.
So shall I just setup one big SQL Server 2008 x64 Std. VM as stand alone and then configure the Hypervisor HA ?
So shall I just setup one big SQL Server 2008 x64 Std. VM as stand alone and then configure the Hypervisor HA ?
Hypervisor HA will give you an outage of several minutes. If that's okay.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh, so the SQL Server 2008 clustering at the OS level and then the underlying VM is just normal deployment ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the reply mate, here;s what I'm going to build:
ESX1:
VM1: Windows Server 2008 Standard + SQL Server 2008 Standard (RDM into the SAN) - clustering mirror
ESX2:
VM2: Windows Server 2008 Standard + SQL Server 2008 Standard (RDM into the same SAN LUN as above) - clustering mirror
ESX1:
VM1: Windows Server 2008 Standard + SQL Server 2008 Standard (RDM into the SAN) - clustering mirror
ESX2:
VM2: Windows Server 2008 Standard + SQL Server 2008 Standard (RDM into the same SAN LUN as above) - clustering mirror
Yes, make sure you TEST TEST TEST and TEST clustering before transfer of databases.
and then, transfer/copy databases and get your DBAs to TEST TEST TEST and TEST.
Before going Production.
and then, transfer/copy databases and get your DBAs to TEST TEST TEST and TEST.
Before going Production.
ASKER
Many thanks for the reply guys.
ASKER
At the moment the SQL Server is spread across several smaller servers 3-4 SQL Server 2000 and 2005 with the total of 70 DB inside those servers, what I'd like to do/build is to migrate them all into SQL Server 2008 in which I must make it redundant so that if one server failed for whatever reason, the other instance can just pick it up straight away.
so from several smaller SQL Servers, I want to consolidate them all into one more powerful SQL Server 2008 x64.
but so far don't know which technology that is suitable for that or if it is possible to do in SQL Serve 2008 Standard.