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.