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!

Advertisement

About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on March 6, 2013, in AlwaysOn and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: