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.
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 Server 2008 Standard.
Any suggestion and comment would be greatly appreciated.