Your search for "availability+groups" returned 100 results:
Hello This new feature "sql server 2016 distributed availability groups" is awesome. But can you please explain the few key pros and cons of this feature to understand in scenario it can well and there it won't fit at all?
2018-07-29
491 reads
Hi All, I got AlwaysOn alert from our monitoring system that some databases are not synced, then I check the sql server log and event viewer, found there is pattern of the issue, which occurs every hour. The error indicates there is connection timeout, googled the message I double checked the NT AUTHORITY\SYSTEM permission, it […]
2015-06-10
2,128 reads
Hi, I am using SQL Server 2016 Enterprise. I am confused as to how each SQL Server can have its own set of data if it is configured within a WSFC. If the WSFC is using shared storage, does it not follow that each SQL Server will also be using shared storage by default? It […]
2018-06-11
5,530 reads
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
6,209 reads
I have several 2012 availability groups running on a cluster. I have one database that is bulk loaded every 30 minutes. The DB is about 1 GB in size. To be on the availability group it has to be set to full recovery mode, but simple or even bulk would obviously be better. Is there […]
2014-08-14
413 reads
Hi, If I have Server A and Server B and want to use them both like active active sql clusters but with Availability Groups so not true SQL clusters do I need to create a different cluster on each server? On Server A I have created a failover cluster called clusterA with two nodes Server […]
2016-04-12
714 reads
Hello, I am testing the setup of contained availability groups. I am getting some strange errors while creating contained availability groups both through wizzard and with TSQL. I started with creating a contained availability group with the wizzard on MSSMS. Setup: I clicked the contained checkbox. The databases Meet prerequesites (FULL backup was made beforehand). […]
2024-04-09
228 reads
Hello SSC, I am having trouble with adding a secondary replica to my availability group. Once I choose the server/instance to connect to, the "Next" button on the Add Replica wizard is grayed out. The server I am trying to add is part of the same Windows Cluster, has AlwaysOn Availability Groups enabled, has the […]
2017-06-12
3,956 reads
I heard that Database Mirroring is going away in SQL Server and Availability groups will be used instead. My only issue with that is right now Traditional Mirroring doesn't require a cluster. Clusters require domain controller permissions for the Machine accounts($machinename) to create cluster name objects in AD. If you don't have any control over […]
2013-09-17
29 reads
Does anyone know if Azure absolutely requires windows clustered services to support availability groups? Most of the articles I'm finding in Google are fairly old. I'm about to demo standalone SQL instances using availability groups to one of my senior leaders and heard someone say we were considering moving to Azure. Can Azure do standalone […]
2023-06-07
37 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
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