January 28, 2010 at 6:08 am
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
January 28, 2010 at 6:14 am
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
---------------------------------------------------------------------
January 28, 2010 at 7:20 am
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
January 28, 2010 at 7:22 am
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?
January 28, 2010 at 8:02 am
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?
---------------------------------------------------------------------
February 1, 2010 at 12:20 am
I am in hi-safety.
February 1, 2010 at 3:19 am
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.
---------------------------------------------------------------------
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply