Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failover Failed Expand / Collapse
Author
Message
Posted Thursday, January 28, 2010 6:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, July 19, 2014 8:57 PM
Points: 310, Visits: 650
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
Posted Thursday, January 28, 2010 6:14 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:21 PM
Points: 5,975, Visits: 12,883
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
Posted Thursday, January 28, 2010 7:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, July 19, 2014 8:57 PM
Points: 310, Visits: 650
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
Posted Thursday, January 28, 2010 7:22 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:41 PM
Points: 23,033, Visits: 31,555
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?



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
Posted Thursday, January 28, 2010 8:02 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:21 PM
Points: 5,975, Visits: 12,883
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
Posted Monday, February 1, 2010 12:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, July 19, 2014 8:57 PM
Points: 310, Visits: 650
I am in hi-safety.
Post #856963
Posted Monday, February 1, 2010 3:19 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:21 PM
Points: 5,975, Visits: 12,883
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 »

Add to briefcase

Permissions Expand / Collapse