Good day SQL friends,
I'm looking for an opinion on an architecture I'm thinking of rolling out.
I have a HA cluster with 3 nodes:
Primary -- Main SQL Server
Failover -- Passive node, only used in DR scenario
Reporting -- Read Intent only queries directed here, SSRS.
Pretty standard stuff.
I am pondering with the idea of balancing the backups out between 2 nodes as follow:
Primary: Full backup weekly, daily incremental.
Reporting: Log backups every 5 minutes.
I have tested that I can indeed restore the logs from the secondary node using the Full and Diff from the other server, no worries there.
My concern is what will happen to the logs on the primary and fail-over server. Will they just grow, grow and grow?
In the past I've always backed up everything on every server.
Thanks for any opinions!