Your search for "availability+groups" returned 100 results:
I've set up a test availability group with a test db. there's no app that connects to the db. I receive sometimes daily, sometimes every two or three days various repeating errors in the SQL log relating to the health of the AG. Curiously they are all of normal business hours (i.e 8am-6pm) and each […]
2016-06-08
800 reads
Oct 24, 2019 ... Finding the Primary Replica of an Availability Group · #set $ServerName to any node that's part of the AG that you're interested in · $ ...
Hi all Bit if an unusual one here, and you’ll have to forgive me for the lack of examples, it was found while recovering from a big failure in our production environment. We use SQL Server 2016 with Availability Groups, and we’re configured with a readable secondary which is where we take our backups from. […]
2020-01-19
44 reads
Hello, I am attempting to create a SQL Server Distributed Availability Group in my Azure EC3 environment. When I attempt to alter my Distributed AG on AG2 using the below command, I get an error as shown below the command. ALTER AVAILABILITY GROUP [WOASQLDISTAG]JOINAVAILABILITY GROUP ON'WAOAG1Hfv96xWgv' WITH(LISTENER_URL = 'TCP://WAOAG121jAavqBc.WAOAG1.com:5022',AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,FAILOVER_MODE = MANUAL,SEEDING_MODE = MANUAL),'WAOAG2cJ22S7mQO' […]
2021-09-01
452 reads
I could try this , was wondering if anyone has tried this before. I have AAG read-only intent enabled, if i have a sproc that does bunch of reads from one database and writes it to another database, would the read-only type queries automatically get transferred to secondary instance?
2016-07-26
124 reads
Good day all. I am hoping someone has run into this issue before. We have two SQL instances on separate servers that are using Always On. Not all the databases on the second node are participating in the Always on. When trying to create a stored procedure on one of the databases that is NOT […]
2017-10-09
28 reads
Hi, I'm sure this is an easy answer for many of you but, when setting up AlwaysOn Availability Groups for the first time, I noticed the wizard takes a full backup of the primary database and restores it to the secondary server. Is this backup a copy-only backup? The reason I ask is because I […]
2017-11-07
120 reads
Hi all, I'm looking at using Cluster Shared Volumes on a new Windows Server 2012/SQL Server 2014 cluster. Each instance is going to be configured to use cluster shared volumes. Is there any reason why Availability Groups couldn't be used in conjunction with Cluster Shared Volumes ? Many thanks Frant
2015-08-12
193 reads
Is it possible to use a listener with a read scale availability group? I have read on some sites you cannot use one but in others that you can. If so what IP addresse do you use for it? I have tried to assign a new one in the subnet and also using the IP […]
2019-07-26
307 reads
Hi, I want to set up several Basic Availability Groups in Standard Edition of SQL Server 2016. Each of the availability groups will have its own listener. How is the application able to connect to several listeners at the same time? Is it possible to alter the application connection string with details of more than […]
2018-03-07
1,226 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...
I have had a hard time to understand how to use EXISTS. I Always...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers