Your search for "availability+groups" returned 100 results:
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,328 reads
Good day all. I am hoping someone has run into this issue before. We have two SQL instances on separate servers that are using Always On. Not all the databases on the second node are participating in the Always on. When trying to create a stored procedure on one of the databases that is NOT […]
2017-10-09
28 reads
Hi, I'm sure this is an easy answer for many of you but, when setting up AlwaysOn Availability Groups for the first time, I noticed the wizard takes a full backup of the primary database and restores it to the secondary server. Is this backup a copy-only backup? The reason I ask is because I […]
2017-11-07
120 reads
I am working for a small company and have been placed in the roll of a DBA. I am a systems engineer with SQL knowledge. I know enough to be really dangerous. 🙂 I am not the original writer of this query. But I need to figure out how to make it work for my […]
2016-12-05
326 reads
Hello,I supported SQL Server Clustering for a number of years, but now I am facing a task to implement Availability Groups either on Windows 2016 Failover Cluster(without SQL Server Cluster) or utilizing SQL Server 2017 Cluster on a Windows 2016 Failover Cluster. What are the advantages and/or disadvantages of utilizing the above 2 methods? There […]
2018-07-08
112 reads
Hi. I have setup a 3 server setup with two availbility groups with two different listeners where one is suppose to be legacy DB and the other production. I really want to limit the legacy availability group resources and want to use resource governor to limit the resources. Is this possible?
2013-01-18
411 reads
The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...
2015-04-02
12,331 reads
Hi, I want to set up several Basic Availability Groups in Standard Edition of SQL Server 2016. Each of the availability groups will have its own listener. How is the application able to connect to several listeners at the same time? Is it possible to alter the application connection string with details of more than […]
2018-03-07
1,226 reads
2012-08-28
33 reads
I have a Sr. Sysadmin here who wants to turn on storage dedupe for the three nodes that will be host AG's because he really wants space savings. The setup is that I actually have 3 sets of 3 nodes. Each set of three nodes will be hosting databases from what is now a single […]
2019-11-25
137 reads
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
First off, my apologies for what could potentially be a bad title! I am...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers