chrisph (9/24/2015)

---

@Jackin, how do you force a checkpoint?

@perry, 4 databases, one large one is causing the errors.

Full and log backups are set to primary, nightly fulls, 30 min tran logs.

SQL2014...

what TCP port number did you use for the Listener

execute the following query in your chosen database

Checkpoint

chrisph (9/24/2015)

---

@perry, 4 databases, one large one is causing the errors.

Full and log backups are set...

nari.koud (9/24/2015)

---

I have Configured always on Availability groups between Server 1 Primary Replica(Active), server 2 Secondary Replica(Passive) on top of WCFS...

Listener Name: AGListner( CLIENTS/APPLICATIONS connect using this Name)

Testing Scenario...

You're in conflict here

PretendDBA (9/22/2015)

---

as long as we test it and confirm the replica db never...

Siten0308 (9/23/2015)

---

1. has a database about 100gigs ish, but the transaction log file are about 5-10kb, I want to log ship from prime location to secondary, will I run into...

balcock (9/23/2015)

---

"If we fail over a SQL AG group on a failover cluster from one node to another making the secondary the new primary, is there any reason why we...

nemesis101 (9/23/2015)

---

Hello Community,

I have a concern in regards to AG and read-only intent.

So have I have an environment with 2 nodes, setup under AlwaysOn.

Everything is establish, but I'm concern in...

Hadrian (9/24/2015)

---

I come back with some details- we have two node cluster 2012 and we should move on new SQL cluster 2012 with disks on the...

chrisph (9/23/2015)

---

Bumping this. I am still receiving the 'availability_replica' errors and backups do not resolve this, I need to remove the database from the availability group first and re-add...

how many nodes in the cluster?

mirroring or AO groups?

etc etc

Throw a dog a bone here

either move the whole database or maybe use replication if it's an option, depends on your requirements and environment

NT AUTHORITY\Network service account acts as the computer on the network, any remote shares accessed by the sql server service will need the computer account to be granted privileges.

A domain...

riazjee-993186 (9/22/2015)

---

Dear All,

I am trying to setup a 2-Node SQL 2008 Cluster on Windows 2008R2 (64-bit) using the sliptstream (SP3). I am getting the following error in the end:

The cluster...

Firstly, ready through my stairway to HA on this site starting at this link

http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/[/url]

PretendDBA (9/21/2015)

---

It seems the only real way to achieve an as live fully offloaded DB for reporting...