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
504 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,506 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,021 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,209 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
248 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,237 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,797 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
512 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,773 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,585 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers