SQL 2008 DB mirroringQuestion:
Posted on 2011-02-16
I am setting up DB mirroring, with Principal Server (with W2K8 R2 OS and SQK 2008 64 bit) being a physical server - Blade G7 (high spec with 2 CPU, 6 cores each and 96 GB RAM), and a Mirror server to be set-up in VM (ESX 4.0), a witness in physical box (DL 320).
Following are the DB;s in existing three servers that need to be migrated to this new DB mirroring.
First server: 1 instance with 2 x DBs (High usage) SQL 2008 on W2K3 64 bit OS
Second server: 1 x Sharepoint farm instance with 30 DB's runnning SQl 2005 Ent on W2K3 OS.
Third server: 5 instances with a total of 15 DB's, running SQL 2005 Ent on W2K3 OS
My question is can I have multiple instances set-up in DB mirroring in order to migrate above Instances/DB's to my new DB mirroring? if so what are the limitations and pre-caution(s) I need to undertake?
Thanks and Regards