Mirroring failover

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mmalatek - 22 Jul 2008 17:38 GMT

I am a little confused about what to do after I fail over to the mirrored
server. I am running mirroring in high protection without a witness server.
What is the best way to manually failover to the mirrored database. And then
how do you set the primary to take back over.

I know I can issue a failover using this command
ALTER DATABASE dbname SET PARTNER FAILOVER;
But what if the server is down?

Reply to this Message

TheSQLGuru - 22 Jul 2008 18:59 GMT

I feel obligated to point out here that you REALLY should have figured out
all the possible scenarios (all of which are already covered I think by BOL
and/or online examples). :-)

Big question is will the primary be put back online or will the secondary be
used as the 'new primary' indefinitely?

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

>I am a little confused about what to do after I fail over to the mirrored
> server. I am running mirroring in high protection without a witness
[quoted text clipped - 6 lines]
> ALTER DATABASE dbname SET PARTNER FAILOVER;
> But what if the server is down?

Reply to this Message

mmalatek - 22 Jul 2008 19:03 GMT

Primary will be put back online

>I feel obligated to point out here that you REALLY should have figured out
>all the possible scenarios (all of which are already covered I think by BOL
[quoted text clipped - 8 lines]
>> ALTER DATABASE dbname SET PARTNER FAILOVER;
>> But what if the server is down?

Reply to this Message

TheSQLGuru - 22 Jul 2008 23:12 GMT

Seems like what you are looking to do can be found in Books Online. See
here:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a782d60d-0373-4386-bd77-9ec192553700.htm

Or here:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/00a5fbc0-af53-46a7-bfb1-405b9ad2427b.htm

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> Primary will be put back online
>
[quoted text clipped - 12 lines]
>>> ALTER DATABASE dbname SET PARTNER FAILOVER;
>>> But what if the server is down?

Reply to this Message