September 22, 2023 at 8:03 am
I need some help regarding How to Setup Backups and Restore planning in SQL Server Availability Groups. Any details link to a blog post or video tutorial would be helpful.
September 22, 2023 at 1:43 pm
Have you taken a look at this: Configure backups on secondary replicas of an Always On availability group
or this ( and the following ): Understanding backups on AlwaysOn Availability Groups – Part 1
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 29, 2023 at 10:09 am
Start with the RTO and RPO of the databases. This will guide you on the backup scenario you need. Having the databases in an AG makes no difference to what you need to do re backups.
An AG can make a difference regarding which node the backups run on. If you have licenced only a single node you have to run the backups on the primary node. If you have licences for two nodes you can run the backups on either the primary node or one of the secondary nodes.
You will need to set up your backup jobs on all nodes, and work out how to enable and disable running the jobs during failover. Alternatively if you are on SQL2022 you could use a Contained AG and put the jobs in the AG instance of msdb.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply