Your search for "availability+groups" returned 100 results:
Yesterday I was working on some T-SQL code to create an AG and add databases to the AG. My scripts worked fine, or so I thought. Silly me forgot to check the secondary nodes. Apparently ALTER AVAILABILITY GROUP [MYAGName] ADD DATABASE MyDBName; only added the database to the primary node of the AG and it […]
2023-10-13
409 reads
Hello SSC, My ideal process for a new Availability Group install would be to:1) Create the Availability Group (without the user database)2) Create the Listener3) Install application directly to the Listener In the past I had posted a question regarding the "install order" for Availability Groups to see if the above was possible. Someone linked […]
2017-09-11
2,362 reads
Evening All, I know the rule of thumb is don't touch the Preferred Owner settings (apart from the Priority Order) but I am wondering how it effects an Availability Group I've 4 node Availability Group Cluster. 3 Automatic Failovers with Synchronous Commit and a Asynchronous with Manual failover. When the Group is owned by Replica […]
2017-06-04
1,499 reads
Hi All, I am looking for some inputs on how to avoid or prevent this particular scenario which happened yesterday. there was downtime of around 2 hours. Below is the scenario We have a Multi-subnet Alwayon AG configured with 10 databases. AG has 3 nodes. All are azure VMs. 2 nodes in one region and […]
2022-08-09
476 reads
Hi all, I have read the stairways to alwayson series. I have also understood alwayson does not need any shared storage resource. But Alwayson sit on WSFC (assume it is a 2 node WSFC) - surely WSFC would need a shared disk (voting/witness) for maintaining quorum ? So a shared disk is needed after all […]
2016-08-22
3,085 reads
I just got called in on an SSISDB / AG issue. We had a fail over event and suddenly a job that calls a package in SSISDB is not working because the package isn't decrypting properly. So we start digging into it and I found something interesting. For kicks and giggles, I opened the AG […]
2023-05-18
427 reads
I saw another post touching on this, and it sort of sounded like people just stayed away from the "mess" entirely 🙂 The MSDN doc makes it sound like after a failover of the primary, the CDC data won't "keep working" on the secondary unless you "To allow the logreader to proceed further and still […]
2015-04-02
325 reads
I am trying to better understand this SQL Server 2016/2017: Availability group secondary replica redo model and performance – MSSQL Tiger Team SQL Server 2016/2017: Availability group secondary replica redo model and performance It talks about log redo, but what IS that exactly? I always though log redo was like rolling forwards so if your server […]
2018-06-04
478 reads
Hello, I read that in new SQL is Ag feature also for sync system database, can you give me some hint please ? I cannot find how to set. thanks
2020-02-18
849 reads
We have 3 databases on a standard edition of SQL server 2019. Now we would like to set up it for HA and DR. Since we are running standard edition, I know there is some limitation of the basic availability group. I am wondering if it is worth to purchase Enterprise license considering cost. Or […]
2022-11-10
3,000 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