SQL Server mirrored database is stuck in recovery mode
Restart the db mirroring end point:

--To stop 
ALTER ENDPOINT&lt;Endpoint Name&gt; STATE=STOPPED

--To start
ALTER ENDPOINT&lt;Endpoint Name&gt; STATE=STARTED


TECH note: if there are multiple databases, not just the one in error, then stopping and starting the enpoint affects all the databases on that endpoint. This can cause problems on a production system like SharePoint. To fix, go the other mirrored database server and enter the same commands:
 ALTER ENDPOINT  STATE=STOPPED
 ALTER ENDPOINT  STATE=STARTED

How to find the name of the end point? 
select * from sys.endpoints  &lt;- works for SQL 2012
The name will be of " type=4 " for mirroring.