Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,842 reads
Search results for "availability+groups"
Your search for "availability+groups" returned 100 results:
Create multiple Basic Availability Group SQL 2016 standard edition
Hello, I have a quick question regarding to BAG in SQL server 2016 standard edition. Can i create multiple BAG with multiple databases and fail-over using multiple listener? Or is there any other way to fail-over multiple BAG at the same time?
2016-12-09
1,116 reads
How can I use Transactional Replication with Basic Availability Groups?
Hi All, Say I have two datacenters. Each one has two instances of SQL Server. The pairs use transactional replication between the two at each datacenter. DC1 is the primary and DC2 would be the secondary. SO like: DC1: SQL1 -> SQL2DC2: SQL3 -> SQL4 Now what I'd like to know is if SQL1 and […]
2019-03-26
255 reads
Have Availability Groups Gotten Easier Lately? - Brent Ozar ...
Dec 3, 2018 ... The secondaries are not meant to ever become primary, they're only there as readable secondaries and they receive reporting / some async read- ...
Steps for Installing AlwaysOn Availability Groups - SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
2020-12-07
120,797 reads
Check Availability Group inside Resource Governor Classifier Function
Morning All, Has anyone put any logic into their classifier function that checks to see if named availability groups are active on the same server. What I am investigating is the following scenario. Consider I have 3 Replicas and 3 Availability groups. They all tend to reside on different replicas.When a group moves to another […]
2017-06-05
66 reads
Restoring backup to AlwaysOn Availability Group primary server.
I'm a bit of a novice when it comes to AlwaysOn, so I was hoping some of you that have expertise in this area can help me understand the high-level process for restoring a database to an AOAG cluster. Is it simply: 1) Disable AOAG2) Delete the database from the primary3) Restore database to primary4) […]
2018-05-01
8,329 reads
Cluster Shared Volumes and Availability Groups
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
DBCC Shrinkfile on data file with Availability Group - Is it safe?
I need to shrink a data file on the primary replica of an availability group. The limitations surrounding AGs and shrinking log files, as well as the workarounds, are well documented. Thus my concern. I'm not finding reports of any similar issues when it comes to shrinking data files though. Is it safe to shrink […]
2020-05-26
3,260 reads
Availability Group Errors
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
793 reads
Blogs
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Forums
One more reason to use foreign key constraints
Comments posted to this topic are about the item One more reason to use...
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers