Tags » Always On

Moving database files of a database in AlwaysOn Availability Group

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

SQL Server

7 ways to Query Always On Availability Groups using SQL

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

Often Overlooked Step when Configuring WSUS to Use SQL Server Always On

Documenting this issue on my personal tech blog because I got stuck with this for the past couple of weeks.

Scenario

  • Windows Server 2016, for ConfigMgr Primary Site Server and multiple Software Update Points…
  • 487 more words
Microsoft

View your Failover Cluster from the DMV's

Just a quick post this time , I was fumbling around the DMV’s the other day looking for a specific Availability group DMV that I just couldn’t remember the name of – I think we have all been there before with some of the DMV names! 223 more words

How to add and remove a database to an availability group in Always On

How to add and remove a database to an availability group in Always On

Rule:

  1. Connect to the server instance that hosts the primary replica.
  2. 454 more words
Database Administration

Are You Always "On"? Living in a Connected World: Segment 3

We live in a digitally connected world, where many of us are regularly “on.” However, some firms are still fighting back against this phenomenon. Consider this example… 208 more words

Living in a Connected World: Are You Always "On"? Segment 3

We live in a digitally connected world, where many of us are regularly “on.” However, some firms are still fighting back against this phenomenon. Consider this example… 207 more words

Part 3: Targeting Customers And Gathering Information