Skip to main content

New answers tagged

0 votes

Failover multiple Basic Availability Groups

I use the following script: --Generate failover script. Execute from the PRIMARY DECLARE @FailoverScript NVARCHAR(MAX) = '' SELECT @FailoverScript = @FailoverScript + 'ALTER ...
Petar Samnaliev's user avatar
3 votes

Failed to open the explicit specified database

That error means that either the user doesn't have access to the database, or the database doesn't exist. It's ambiguous because if a user doesn't have access to a database, the user also can't ...
David Browne - Microsoft's user avatar
4 votes

Deny access to Sql Server replica when it becomes primary

the primary fails and the secondary becomes the primary; the reading load is not desired since it will effect mission-critical loads (that are transferred to the new primary). We can tolerate outage ...
SqlWorldWide's user avatar
  • 13.5k
1 vote

SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)

In the scenario of an AG Listener Resource Group with multiple "Cluster IPs," you need to make sure that each Resource has only one possible owner!
Borik's user avatar
  • 227
0 votes

SQL Server Standard and Enterprise editions in AlwaysOn Availability Groups

Can two different versions of SQL Servers participate in AlwaysOn Availability Groups? I am specifically talking about SQL Server 2019 Standard and SQL Server 2019 Enterprise. Nope. AlwaysOn ...
J.D.'s user avatar
  • 38.1k
1 vote

Does availability group listener runs on both SQL Server nodes or does it run on a separate machine

My question is, which IP address shall I define for this listener? You'll need a new IP if you're using a traditional listener, or if utilizing a distributed network name (dnn) it'll use the local ...
Sean Gallardy's user avatar
1 vote

Azure MS SQL Always On Availibity Group Setup Issue

I have 2 VMs on azure where MS SQL server is configured with always on high availability, one VM is acting as primary and other one is secondary. But the problem is sometimes my app creates ...
Sean Gallardy's user avatar
1 vote

How to configure listener when using read scale AG?

It seems that the listener must be pointed to the primary node ip [...] Correct. And after failover, the listener IP must be updated to point to the new primary node IP [...] Correct. However I'm ...
Sean Gallardy's user avatar
2 votes

2x SQL Server 2019 in AlwayOn group - how to remove transaction log

There are supposed to be some way how to purge the log by doing some kind of backup, but never found real help on that. They're called Transaction Log backups. For a database that's set to the Full ...
J.D.'s user avatar
  • 38.1k
2 votes

2x SQL Server 2019 in AlwayOn group - how to remove transaction log

Simply put, we don’t need the log, we don’t want the log, how to get rid of that? You don't. SQL Server requires it to run and Always On requires it to function properly.
Sean Gallardy's user avatar

Top 50 recent answers are included