All Questions
Tagged with automatic-failover sql-server
3 questions
1
vote
1
answer
468
views
Should we have to use Failover Group server name or Primary server name in SQL Server managed instance connection string
We have configured a failover group for our SQL Server Managed Instance in Azure portal:
Primary Managed Instance : myprod01.asbcdef.database.windows.net
Failover Group Name : failover-myprod01....
- 93.9k
1
vote
0
answers
13k
views
Find out when the last failover occurred in AlwaysOn availability groups
I used below metioned query to find out if any failover happened in the last 30 minutes
create table #errormsg(duration datetime,errornum int,dbmessage varchar(max))
DECLARE @tags3 VARCHAR(5000)SET @...
- 11
1
vote
1
answer
471
views
Issue in Azure Auto-Failover Group with Azure SQL
Am working on the Azure SQL with Auto-Failover Group, for this I created one SQL Server along with one database and I created another copy of database in another SQL Server which is created with the ...
- 1,334