Your search for "availability+groups" returned 100 results:
I had something occur with my availability groups that has me concerned. My primary failed on me, due to the inclement weather and ice storms, the ISP lost connectivity and will be down for some time. But my secondary didn't failover and handle the traffic. Instead, I found it in "Recovering Mode" and when I […]
2021-02-15
537 reads
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
13,586 reads
Hi, I would like create az availability group without Windows Server Failover Clustering. I have a primary server and a secondary with SQL Server Enterprise 2017. I have done availability group but when I trying join secondary server to the group it is drop an error: "An attempt to fail over or create an availability […]
2017-12-07
15,116 reads
Hello, I'm working on migrating from an existing multiple FCIs to Instances with availability groups. I'm attempting to keep the impact to my customers as small as possible so I'm wondering about connection strings with availability groups. Current Environment, multiple instances some as named instances in existing FCI SQL1 and SQL2\NamedInstance Proposed new environment. Physical […]
2022-02-22
1,242 reads
We are planning to upgrade our production servers from mirroring to alwayson. Our current mirror setup gives the advantage that it can failover a single database. To have a similar setup in alwayson we are probably going to create an availability group per database. Does anyone see any disadvantage in this except for the extra […]
2015-06-26
256 reads
I want two write a small script to determine which is the currently active (primary) server in the AG. Right now, I see that using SELECT * FROM SYS.dm_hadr_availability_replica_states I can determine the role. However, when the server goes down and switches to the secondary node, I don't believe that the role changes (or does […]
2014-11-25
2,389 reads
My company is getting ready to make a major architecture change and one of the things we are trying to do is reduce our actual virtual server footprint. Currently we are running 22 separate availability groups each with their own windows cluster across 44 servers (SQL Server 2014, Windows Server 2012R2 VMs). We want […]
2017-05-25
3,811 reads
My understanding is that when performing a manual or automatic failover of an availability group in synchronous mode. Any uncommitted transactions on the primary are rolled back, committed transactions are safe. I have tested this and the ms documentation confirms my understanding is correct. Does anyone know if there is a way to failover only […]
2017-01-24
526 reads
Hi, I've been working on setting up AOAG for the first time. I see a lot of benefits to having this in place. However, I'm a little bit fuzzy on a couple of things and I'm hoping someone can help clarify my understanding. I have the simplest of setups: -1 Availability Group.-2 replicas (primary, secondary […]
2018-02-26
3,625 reads
I have a 4 node always on availability group setup across two datacentres with synchronous replication from node to node in the same site and asynchronous from nodes site to site. I am setting up Index maintenance using Ola Hallengren's scripts and am very wary of the fact of rebuild/reorg indexes in an always on […]
2020-02-18
2,801 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
Comments posted to this topic are about the item Multiple Display Productivity
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers