I just set up sql mirroring in 2012 and think it is pretty slick. My question is this: if my primary server goes down and will not come back up, how do I failover on the mirror side?
I know I have to open up a query and run the following:
ALTER DATABASE <database_name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_L
which I found at the following website: http://msdn.microsoft.com/en-us/library/ms189270(v=sql.105).aspx
But I'm not sure what to do after that. Any help would be greatly appreciated.