For transaction log backups, the backup will only be taken off the preferred replica. If a secondary replica is the preferred replica, then a full backup will be made with the COPY_ONLY option added. On SQL Server's side, you would need to set up the secondary replica's backup priorities so that only one of them will actually run the backup job.įor full backups, if the primary replica is the preferred backup replica, a full backup will be made. The simplest way to go about this in SQL Backup is to create 2 backup jobs on every one of the nodes:ĮXEC master.sqlbackup '-sql "BACKUP USER DATABASES TO DISK = WITH CHECK_PREFERRED_AG_REPLICA, SECONDARY_REPLICA_COPY_ONLY"'ĮXEC master.sqlbackup '-sql "BACKUP LOGS TO DISK = WITH CHECK_PREFERRED_AG_REPLICA, SECONDARY_REPLICA_COPY_ONLY"'
0 Comments
Leave a Reply. |