sql server Always on patching

• vigneshbeece

  Mr or Mrs. 500

  Points: 569

  More actions

  March 12, 2020 at 2:28 pm

  Go to Answer

  #3733634

  Always on(SQL server 2016) is configured between four standalone servers Server1,Server2,Server3,Server4. These servers contains one availability Group(AG01) which contains 3 databases. How to apply SQL server patch for these servers? Do we need to apply patch for all servers at same day or on two different days?  These servers are production servers.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  March 12, 2020 at 2:32 pm

  Answer

  #3733639

  One at a time, making sure you're always patching a server that isn't hosting the AG.  You don't have to do them all on the same day, although it's best to do them in as short a time as possible, so that you're not running different versions on different nodes for prolonged periods of time.

  John