AlwaysON quorum vote question for Disaster recovery only setup

-

hello,

i planning implement alwayson synching data between main site , dr site in asynchronous fashion. 2 node set up, 1 on main site , on dr site. far voting goes, have read in multiple white papers common remove quorum vote dr node. leaves 1 node (on main site) with vote of 1 , since it's odd number guessing that i don't need set file share witness additional vote.  my question is:

a. does topology of alwayson 1 node on main site , 1 node on dr work without file share witness work?

b. voting 0 dr node , 1 main site node makes sense?

c. periodically (once or twice year), dr test. during time, need failover dr site and test. but, after test done, need perform full database backup/restore main site dr site before setting alwayson or there better way don't need full backup/restore? has similar setup , these test periodically, love hear solution options.

sql server version using sql 2012.

i appreciate reply. thanks.

raj

hi kraj1,

>> a. topology of alwayson 1 node on main site , 1 node on dr work without file share witness work?

yes work. however, in two-node setup without witness, have 50/50 change keep cluster online if lose 1 node.

>> b. voting 0 dr node , 1 main site node makes sense?

depends on want. in configuration, if lost dr node, main node still online. if lose main node, cluster taken offline.

>> c. periodically (once or twice year), dr test. during time, need failover dr site , test. but, after test done, need perform full database backup/restore main site dr site before setting alwayson or there better way don't need full backup/restore? 

in asynchronous-commit mode, failover option forced failover(with possible data loss). correct me if i’m wrong, if data loss in unacceptable during failover, should take backups before setting alwayson. more information, please review bol.

if have other questions, please let me know.

regards,
lin


SQL Server  >  SQL Server High Availability and Disaster Recovery



Comments

Post a Comment

Popular posts from this blog

more indexes

-
i want 2 indexes. likes can't mssql. i have example fields: school class number i want school , class in index can this: school class number 1 2 435 1 4 4535 1 5 265 2 1 8234 2 2 8493 4 3 943 4 2 493 4 6 934 but how can in sql server management studio i declare unique constraint. borrowing segio's ddl: create table dbo.orderrows ( id int identity (1, 1) not null primary key ,ordernr varchar (20) not null ,orderrow varchar (20) not null ,rowtotal decimal (11, 3) default 0 not null , constraint uq_orderrows unique (ordernr, orderrow) ); above under hood create unique index on column combination (ordernr, orderrow). tibor karaszi, sql server mvp | web | blog SQL Server  >  ...
Read more

ActiveDirectory

-
hello togehter, is possible disable bloody warning?: event id: 2887 event source: activedirectory_domainservice event type: warning event description: during previous 24 hour period clients attempted perform ldap binds either: (1) sasl (negotiate kerberos ntlm or digest) ldap bind did not request signing (integrity validation) or (2) ldap simple bind performed on cleartext (non-ssl/tls-encrypted) connection directory server not configured reject such binds.  the security of directory server can enhanced configuring server reject such binds.  for more details , information on how make configuration change server please see http://go.microsoft.com/fwlink/linkid=87923. summary information on number of these binds received within past 24 hours below. can enable additional logging log event each time client makes such bind including information on client made bind.  to please raise setting "ldap interface events" even...
Read more

Virtual Channel

-
on condition rdp decide protocoll extension necessary? use standard gdi , if there movie playing, switch dynamically window ms-rdpev video transfering? or full session send on additional ms-rdpev. , in cases host rendering , in case client rendering? thanks in advance! hi, the remote desktop protocol video redirection virtual channel extension used redirect audio/video streams terminal server terminal client . protocol specifies communication between application playing audio/video on terminal server , terminal client. regards, wilson jia this posting provided "as is" no warranties, , confers no rights. please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread. ” Windows Server  >  ...
Read more