Recently, all the SQL server DBAs in and around the world have started with or have been on the “AlwaysOn Bandwagon”. So, eventually, if the technology doesn’t get replaced by a fresh High Availability technology or gets out-dated, we’ll get requests to move the data files into fresh new disks or add new files to a database in an AG (Availability Group). 261 more words
Tags » Always On
There are multiple ways to query availability group information, below are some of my favourite goto queries when I need to obtain information about Always on Availability groups for various tasks. 1,207 more words
Documenting this issue on my personal tech blog because I got stuck with this for the past couple of weeks.
- Windows Server 2016, for ConfigMgr Primary Site Server and multiple Software Update Points… 487 more words
How to add and remove a database to an availability group in Always On
- Connect to the server instance that hosts the primary replica. 454 more words