I was working on setting up database mirroring on a SharePoint 2010 installation, and my “Mirroring” tab was missing in “Database Properties” in SQL Management Studio.
Configuring it through scripts was possible, but I still wanted the interface.
Here is a screenshot with the option missing:
My installation of SQL Server 2008 R2 Standard was upgraded from SQL Express 2008 R2. The catch here is that the “Upgrade SKU” options don’t install the “Complete” set of SQL Management Tools. So you must go through the installer and explicitly install this toolset.
Now the mirroring option will be available: