Backup / Restore Availability Group following fail-over

  • I have 2 servers in a SQL Server Fail-Over Cluster. IOW I use always-on availability groups. I run backups - full, diff and log - regularly via SQL Agent on one server only depending on which is primary. If there is a fail-over, then backups will continue on the other server. If I have to restore a database in an availability group I probably would need some combination of full, diff, and log backups from each server. Would that actually work? I test the backups weekly however I just realized that I never tested that scenario. Thought I would just ask before I embark on that exercise. Thanks.

  • It will work. You restore DB (full, diff, txlog, whatever) on your primary AG node, then re-sync the secondary replica(s) like you did back when you added the DB to the AG.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply