I wonder if anyone can assist me in clarifying this SQL Server 2008 features for the database consolidation project which put ~ 110 DB files into one node and then mirrored across 1 GB WAN link:
My company is planning to consolidate all of the SQL Server 2000-2008 edition ranging from Enterprise to Standard in just two node only spread across different sites for both Production and DR sites. So at the end of the project there will be just 2x SQL Server database stand alone servers.
Rather than using the 2x Enterprise nodes in each sites (in total of 4x nodes cluster) to minimize downtime during the base Windows OS patching, we are seeking cheaper option by using the Standard edition only, In terms of database recovery, the business accept that during the specific non business hours window, no more than 20 minutes of downtime is accepted.
1. Can we achieve the availability above with just using 2x Standard edition nodes set to replicate with Synchronous mirroring only ?
2. The head server is very powerful with 4x 16 core CPU (in total of 64 CPU) and 256 GB of RAM, does the SQL Server 2008 R2 SP 2 Standard Edition 64 bit capable of utilizing that features ?
Thanks in advance,