Random Mirroring Facts
Today is a hodge podge of facts about mirroring, since I am in learning mode I thought I would share with you.
- Mirroring is deprecated, meaning it is going away and moving to AlwaysOn availability groups. Now is probably not the time to devise a mirroring plan.
- You can mirror some or all of your databases on a particular instance.
- You can only mirror databases in the FULL recovery model.
- Mirroring supports only one principal and one mirror.
- All versions support witness modes but only Enterprise supports high-performance mode.
- Enterprise, Standard and the new BI version all support the high-safety mode.
- You cannot mirror a database that is using FILESTREAM file groups.
- You can only mirror user databases.
Enjoy!
Posted on March 6, 2013, in AlwaysOn and tagged Mirroring. Bookmark the permalink. Leave a comment.
Leave a comment
Comments 0