Brandie Tarvin (8/15/2014)
So here's my question (because I need to put it in my plan): If my data center or Server A goes down entirely, how do I fail over the mirror to Server B?Everything I have found in BOL says I have to do this from the primary server. Maybe I missed a reference somewhere?
You only issue the ALTER DATABASE ... SET PARTNER FAILOVER against the principal when the principal is actually online.
In the situation you're describing, you must either connect to the mirror server and use ALTER DATABASE ... SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS or leave the mirror offline until the principal is brought back online or stop the mirror session to recover the database and start a new mirror session later on.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉