Failover Failed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Failover Failed

Failover Failed

Rate Topic

Display Mode

Topic Options

Author

Message

luckysql.kinda

Posted Thursday, January 28, 2010 6:08 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 10:41 PM
Points: 310, Visits: 649

Hi,

I am using following command for failover but this doesn't happen. My quorum is in High performance mode.

ALTER DATABASE 'DBName' SET PARTNER FAILOVER

-Lk

Post #855118

george sibbald

Posted Thursday, January 28, 2010 6:14 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:35 PM
Points: 5,269, Visits: 11,208

either use 'allow data loss' or if that is not acceptable switch to high safety mode, allow it to synchronise and then do alter database set partner failover

---------------------------------------------------------------------

Post #855126

luckysql.kinda

Posted Thursday, January 28, 2010 7:20 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 10:41 PM
Points: 310, Visits: 649

Ok got it. in case this is sync (High availability) the there is no data loss and we can just issue ALTER DATABASE SET PARTNER FAILOVER.
But there is ofcourse dataloss in async mode then we have to inform sql server about data loss.

But one question... What about HIGH SAFETY (WITHOUT WITNESS). This is also sync. So according to me we can use ALTER DATABASE SET PARTNER FAILOVER. M I Correct?

-Lucky

Post #855222

Lynn Pettis

Posted Thursday, January 28, 2010 7:22 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:07 PM
Points: 21,625, Visits: 27,468

luckysql.kinda (1/28/2010)

Hi,

I am using following command for failover but this doesn't happen. My quorum is in High performance mode.

ALTER DATABASE 'DBName' SET PARTNER FAILOVER

-Lk

Are you getting an error message? if so, what is it?

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #855227

george sibbald

Posted Thursday, January 28, 2010 8:02 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:35 PM
Points: 5,269, Visits: 11,208

luckysql.kinda (1/28/2010)

But one question... What about HIGH SAFETY (WITHOUT WITNESS). This is also sync. So according to me we can use ALTER DATABASE SET PARTNER FAILOVER. M I Correct?

-Lucky

you are correct. which mode are you in normally?

---------------------------------------------------------------------

Post #855276

luckysql.kinda

Posted Monday, February 01, 2010 12:20 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 10:41 PM
Points: 310, Visits: 649

I am in hi-safety.

Post #856963

george sibbald

Posted Monday, February 01, 2010 3:19 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:35 PM
Points: 5,269, Visits: 11,208

then you should be able to use alter database set partner failover. What error did you get?

It must be run from the principal and you must be in master when you run it.

---------------------------------------------------------------------

Post #857017

« Prev Topic | Next Topic »

Permissions