SQL Server DBA Tutorial 169-How to Plan Backups with AlwaysOn Availability Groups in SQL Server

In this video you will learn following:
1- How to plan backups with AlwaysOn Availability Group in SQL Server?
2- What are the backup options in AlwaysOn Availability Group in SQL Server?
3- What is Preferred Secondary backup option in SQL Server?
4- What is Secondary Only backup Option in SQL Server?
5- What is Primary Only backup Option in SQL Server?
6- What is Any Replica backup Option in SQL Server?
7- What is priority backup Option in SQL Server?
8- How to script backup Jobs for Availability Group in SQL Server?
9- How to create and schedule AG Group database backup jobs on all secondary replica
10- Understanding Auto backup preferences in AG database backups

Check out our Website Full DBA Free Tutorial step by Step and other IT tutorials

[JahAdam]

Thanks Brother you are a medicine for all of us who love to working as a DBA🙏

[krismaly]

I enjoyed watching this video.
Host explains the Availability  Group and Backup Options. in detail by listing each type.
I recommend this to others especially for DBAs

Thanks for educating the community and appreciate all your efforts in educating others.

Please keep producing some more videos.

Thanks a bunch

[abealhajjaj]

Thank you for taking the time to compile this Video.

[DannyNilsson]

i had some issues doing this, maybe i missed something but i tried following the example on SQL 2014. where the full backup runs successful. but when using T-SQL the file name gets hardcoded into the script, so no new files will get created. using maintenance plan instead it will create new files on every backup. and if following the T-SQL when doing transaction logs, Copy Only will not work, because its only used for Full Backups and not Tlogs. I cloud get the Tlog working, but again the file name was hardcoded, and it only worked if the backup plan was set to primary only.

what solved my backup plan. was to use the Maintenance Plan Wizard and create the same job on both servers, and from here its also easier to add new databases to the job than needed to edit the script afterward

[ggracia]

You're the best! thanks!
I guess I could use the decision script to run other jobs depending on where the primary replica is, right?
Thanks again!

[papayoga]

Hi, do you know how to make it automatic using timestamp in filename?