Your search for "availability+groups" returned 100 results:
Hi,We are new to SQL 2016 and I'm trying to setup AlwaysOn to replicate a read only database for reporting purposes. I have it successfully setup in my DEV and TST environments but I'm trying to setup Production and I'm getting this error when trying to add a secondary replica:"Failed to obtain cluster information. Either […]
2018-03-12
10,514 reads
What is the recommendations for backups in distributed availability groups? I have AG setup in 2 sites for DR but the backups fail on the forwarder (primary node in Second AG) Log backup for database "DBA_Test" on a secondary replica failed because the last backup LSN (0x00000028:00000993:0001) from the primary database is greater than the […]
2020-01-17
275 reads
All, Here's a bit of code I just put on a StackOverflow answer, so people might find useful. It automatically replicates new databases to Availability Group partners - if you do a little prep work on your environment first. To make it work: 1) Create linked servers on all group members pointing to all other […]
2013-10-28
2,218 reads
I currently have a setup where we have an Active/Passive Cluster Environment that also has a Disaster Recovery Secondary Availability Group. There is a need for another secondary replica to use the read-only functionality to reduce the workload on the Primary Replica. My main question here is I'm assuming I will have to have another […]
2024-02-09
51 reads
Hi, can someone please help me with this situation:Setup is: Two node Always On AG cluster (Node1 and Node2)(Version: 2016)Three named instances with one AG on each node:Ins1:AG1, Ins2:AG2 and Ins3:AG3 Everything looks ok, and all synchronization too.I use the same SQL service account for all instances. On one of the instances I have created […]
2018-09-07
20 reads
I am running the below script to create Distributed Availability Groups, but I get the below error. I am assuming we are getting this error because in a Active/Passive cluster the Passive node is not online. So, my question is how do you get around this? Does Distributed Availability Groups support Active/Passive clusters? Appreciate the […]
2017-08-31
97 reads
Comments posted to this topic are about the item Ensure that SSRS is Working while Using Availability Groups
2020-11-17
120 reads
I have a database I need to migrate to a new environment that is being built. The current environment does not leverage Availability Groups, but the new environment I need to migrate the database in to does use an AG. I need to set up log shipping for the database to facilitate the migration and […]
2020-09-15
148 reads
Here it is more explained. I have a FCI with 3 Nodes, node 1, one database to be Primary, Node 2, two databases to be primary, Node 3, Passive node, and a Stand alone SQL Server Instance to host the 3 Secondary replicas whitin the WSFC. Question 1.- Can I have 3 databases, 1 in […]
2015-03-23
137 reads
This morning one of our databases was not accessible. After investigation, I found that the Always On Availability Group was in "RESOLVING" state. I was able to bring it back online manually via cluster manager. And I knew there were possibly network connectivity issues during the night and in the morning that could have resulted […]
2017-05-22
28,450 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
Hello Everybody, I have a database on which I try to empty a file...
My knowledge of Extended Events is limited, but I am trying to capture some...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers