October 10, 2018 at 5:19 am
Hi
I want to schedule database backup in my SQL Server 2016 AlwaysOn cluster, so appreciate if someone can give the recommendation for my concerns.
1. What is the best recommended backup plan (Weekly Full Backup, Daily Log Backup etc..)
2. Do we need to plan full & log backup both in primary server ? or what are best practices for alwayson backup.
3. And what is the recommended retention period for SQL Server database backup ?
Thanks
October 10, 2018 at 3:21 pm
Some of these have nothing to do with clustering or AGs.
1. What's your RPO/RTO? In other words, how much data loss and how long can you be down? Those determine log and database backup frequency.
2. You'l want to understand how this works. You can schedule some backups on primary replicas, some on secondaries, but you must have ALL backups in a chain to restore. Make sure you know this and practice restoring.
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-backup-on-availability-replicas-sql-server?view=sql-server-2017
https://www.sqlshack.com/understanding-backups-on-alwayson-availability-groups-part-1/
3. See #1. Keep backups that protect your system and ensure restores. I ALWAYS want at least two full backups, and two copies of each. Three if I can afford the space. I need all log backups since the earliest full I keep.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply