Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: basic-availability-groups

SQL Server Basic Availability Group: config-only replica?

By adminPosted on October 31, 2022

Question : In SQL Server Basic Availability Groups docs, I found this interesting line: Basic Availability Groups for SQL Server […]

SQL Server Basic Availability group: one or zero listener for multiple AG

By adminPosted on August 11, 2022

Question : In my testing of SQL Server 2019 Basic Availiiblity Group on Ubuntu 20.04, I successfully created AG1 for […]

Always On Basic Availability Groups stuck as primary on both replicas

By adminPosted on March 30, 2022

Question : I configured Always on basic availability groups on my SQL Server 2019 Standard instances. One as our production […]

Unable to create Always On Basic Availability Group on SQL 2019 Standard, cannot enable Always On feature

By adminPosted on March 17, 2022

Question : I want to create a SQL 2019 Standard BASIC Always On Availability Group for a database in a […]

Should we manually failover again if the node which was originally a primary role and went down recovered?

By adminPosted on March 7, 2021

Question : We have an SQL Server 2016 standard edition with Basic Availability Groups(BAG) setup between dbserver1 and dbserver2. This […]

SQL Always on High Availabity Groups Multi Subnet

By adminPosted on November 6, 2020

Question : SQL 2017 Standard in SQL always on two node Basic AG. There are two DNS records for the […]

Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?

By adminPosted on March 18, 2020

Question : We have a few Basic Availability groups in production and I’ve been reading about the limitations of them. […]

Recent Posts

  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow
  • mysql_query expected [closed]
  • Oracle not using index when > used in where clause
  • Determine databases specified Login has access to on SQL Azure
  • What is the performance overhead of IFNULL in the select statement of mysql 5.7+ query

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding