Comprehensive data protection for all workloads
Post Reply
ibarizz
Enthusiast
Posts: 49
Liked: 6 times
Joined: Jul 28, 2021 2:36 pm
Contact:

Considerations when backing up a SQL Server with Always-On

Post by ibarizz »

Hello, I have a question that I can't somehow answer with the public documentation I've read.

I have few SQL Servers (all VMs) that are part of a Always-On cluster that consist of the following:

- First node (active)
- Second node (pasive replica and works in synchronous-commit mode)

Being said that, does it actually make sense to only backup the first node? Considering that all the bases in there are replicated to the second node, wouldn't it be redundant to have a backup of both SQL Servers? I know it depends on how someone plans its strategy, but I wanna know what is the best practice for this case.

Thank you so much!
Facundo.
HannesK
Product Manager
Posts: 14322
Liked: 2890 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Considerations when backing up a SQL Server with Always-On

Post by HannesK »

Hello,
the best practice is to back up both nodes for proper transaction log processing.

Best regards,
Hannes
Post Reply

Who is online

Users browsing this forum: No registered users and 103 guests