high availability related issues & queries in DbaXchanger

Databases in SQL 2016 AlwaysOn in (Not synchronising/Recovery Pending) state. AG in (Distributed) and replica (resolving)

 sql-server sql-server-2016 availability-groups clustering dbatools
Updated September 18, 2018 00:06 AM

How to find/calculate time taken for synchronization in SQL Always on AG?

 sql-server sql-server-2016 availability-groups
Updated September 16, 2018 16:06 PM

Back up Plan on Always on Using Maintenance Wizard doing T logs on Pirmary and Secondary

 sql-server sql-server-2012 backup availability-groups transaction-log
Updated September 14, 2018 18:06 PM

AG Group failover and quorum

 sql-server-2016 availability-groups clustering
Updated September 14, 2018 17:06 PM

DR/Reporting solution for a large SQL database

 sql-server-2012 availability-groups high-availability
Updated September 13, 2018 13:06 PM

How do Master / Slave JDBC URL handle broken MySQL Slave ?

 mysql mysql-5.7 high-availability jdbc
Updated September 13, 2018 09:06 AM

Setting up Always On Availability Groups with Windows Server Failover Cluster

 availability-groups clustering failover hadr
Updated September 13, 2018 00:06 AM

Always On best practice for secondary node maintenance

 sql-server availability-groups
Updated September 12, 2018 20:06 PM

DBCC CheckDb on Secondary Aynchronous Replica

 sql-server-2012 availability-groups corruption ola-hallengren dbcc-checkdb
Updated September 12, 2018 19:06 PM

Switch-SQLAvailability error during DB Restore in AlwaysON Group

 sql-server-2014 restore availability-groups powershell failover
Updated September 12, 2018 19:06 PM

MSOLEDBSQL Provider Linked Server

 sql-server sql-server-2012 availability-groups linked-server
Updated September 12, 2018 18:06 PM

SQL Availability Groups Failover Readinness "No data loss" and rollback of nonqualified transactions

 sql-server sql-server-2016 availability-groups high-availability failover
Updated September 10, 2018 15:06 PM

Mixing SQL Server 2016 and 2017 in a distributed availability group

 sql-server-2016 availability-groups sql-server-2017 distributed-availability-groups
Updated September 10, 2018 10:06 AM

Pausing the secondary Replicas for a day in always on availability group

 sql-server sql-server-2012 availability-groups failover disaster-recovery
Updated September 07, 2018 16:06 PM

How to create BAG on non-wsfc nodes (SQL Server 2016 STANDARD Edition)

 sql-server-2016 availability-groups clustering
Updated September 07, 2018 11:06 AM

Orphaned Availability Group Name

 distributed-availability-groups
Updated September 07, 2018 01:06 AM

Availability Group Listener - Dedicated Server?

 sql-server availability-groups configuration listener license
Updated September 04, 2018 17:06 PM

Any Reason to have Regular Failover Clustering in Azure Cloud?

 sql-server availability-groups clustering failover cloud
Updated September 04, 2018 08:06 AM

Shouldn't Windows Server Failover Clustering already take care of SQLServer Failover Clustering?

 sql-server clustering high-availability failover
Updated September 04, 2018 06:06 AM

Azure Failover Clustering vs On Premise Failover Clustering

 sql-server sql-server-2016 availability-groups clustering failover
Updated September 04, 2018 06:06 AM

Is it a common pattern in having two AlwaysOn Availability Groups for DR and Reporting?

 sql-server sql-server-2016 availability-groups clustering failover
Updated September 03, 2018 10:06 AM

AlwaysOn Failover Clustering in Azure Cloud Benefits

 sql-server-2016 availability-groups clustering failover cloud
Updated September 02, 2018 19:06 PM

AlwaysON DATABASE_MIRRORING End Point Error: 9642, Severity: 16, State: 3

 sql-server sql availability-groups
Updated August 31, 2018 11:06 AM

On Always On Availability Group

 sql-server sql-server-2016 availability-groups
Updated August 30, 2018 17:06 PM

Availability Group Listener Misconfiguration?

 configuration sql-server-2017 listener distributed-availability-groups
Updated August 29, 2018 18:06 PM

Odd error when stress testing against an AG

 sql-server-2016 availability-groups connectivity
Updated August 29, 2018 16:06 PM

Unable to remove replica from read-scale availability group in SQL Server 2017

 sql-server availability-groups sql-server-2017
Updated August 29, 2018 06:06 AM

Problems of having DR as Synchronous Commit

 sql-server-2012 availability-groups data-synchronization disaster-recovery sql-data-sync
Updated August 28, 2018 14:06 PM

Promoting MySQL slave with unknown replication delay

 mysql replication mysql-5.7 high-availability
Updated August 25, 2018 17:06 PM

Always On Windows Server Edition

 sql-server availability-groups windows
Updated August 23, 2018 21:06 PM

Failover from Primary to Asyn Secondary Replica

 sql-server-2012 availability-groups failover data-synchronization disaster-recovery
Updated August 23, 2018 16:06 PM

Availability Group Always ON 2016 HADR_SYNC_COMMIT

 high-availability
Updated August 22, 2018 04:06 AM

timeline 2 of the primary does not match recovery target timeline 1

 postgresql replication postgresql-9.1 high-availability pgpool
Updated August 21, 2018 14:06 PM

Disabling TDE on AlwaysOn database

 sql-server availability-groups transparent-data-encryption
Updated August 21, 2018 10:06 AM

How do I determine the cause of a SQL 2017 Mirroring Login Failure?

 mirroring high-availability sql-server-2017 read-only-database
Updated August 19, 2018 21:06 PM

Change Database Availbility Group on Same Instance

 sql-server-2016 availability-groups
Updated August 16, 2018 18:06 PM

SQLServer - Detect who is connecting via an AG listener

 sql-server availability-groups listener
Updated August 15, 2018 22:06 PM

HADR wait on servers without HA configured

 sql-server sql-server-2012 availability-groups
Updated August 14, 2018 22:06 PM

SQL Server 2016 SP2 CU2 Availability Group Online but Cluster Offline

 sql-server-2016 availability-groups clustering
Updated August 14, 2018 16:06 PM

Why select query is waiting on HADR_SYNC_COMMIT?

 sql-server availability-groups
Updated August 13, 2018 20:06 PM

Always On - Question Mark on the Primary and Other Secondary Replicas in the Object Explorer?

 sql-server availability-groups
Updated August 13, 2018 17:06 PM

SQL Server Always ON Availability Group Licensing

 sql high-availability license
Updated August 13, 2018 13:06 PM

sys.dm_hadr_database_replica_states, understanding the different *_time

 sql-server-2014 availability-groups
Updated August 13, 2018 03:06 AM

AG Automatic Failover

 sql-server availability-groups high-availability disaster-recovery
Updated August 11, 2018 02:06 AM

Unable to shrink the Transaction Log File on the Primary Database - Always On Config

 availability-groups transaction-log shrink
Updated August 10, 2018 11:06 AM

AlwaysOn Error: The target database is participating in an availability group and is currently not accessible for queries

 sql-server-2014 availability-groups
Updated August 09, 2018 08:06 AM

problem with service broker in always-on

 sql-server sql-server-2016 availability-groups service-broker
Updated August 05, 2018 08:06 AM

Transaction log for standalone DB vs AlwaysON availability Group

 sql-server-2016 availability-groups transaction-log
Updated August 02, 2018 22:06 PM

Hide databases from SQL Server with AG

 sql-server availability-groups security
Updated August 02, 2018 22:06 PM

How to reset or resume transaction log chain for a database in high availability during restore of database

 sql-server-2012 transaction-log high-availability
Updated August 02, 2018 02:06 AM
Showing Page 1 of 0

Query Search

Categories