Forum Discussion

Jeroen_Bleeker's avatar
Jeroen_Bleeker
Copper Contributor
Oct 31, 2023

SQL 2022 Backup in contained Availability Group

Hi,

 

We have a new SQL 2022 Always On Availability Group configured with contained databases. 

We have the possibilty to run the backup jobs with the SQL agent within then contained environment or on the Availability Group members. I searched the internet but could not find a preferred method.

It looks like both methods can be used. 

 

Anyone any idea?

 

Regards, Jeroen Bleeker

  • olafhelper's avatar
    olafhelper
    Bronze Contributor

    but could not find a preferred method.

    Jeroen_Bleeker , what for a preferred method are you looking for; a database backup is a backup?

    • Jeroen_Bleeker's avatar
      Jeroen_Bleeker
      Copper Contributor

      olafhelper thank you for your repsonse.

       

      I want to make database backups; we use the ola halengren scripts.

       

      Regards, Jeroen Bleeker

Resources