0

I do have SQL Server 2014 high availability setup in Prod env.

Server A – Primary, B-Secondary and C -DR.

Server A to B are synchronous commit and automatic failover.

Server A to C are asynchronous commit and manual failover.

I need to setup full-backup and diff backup. Can I do it on Server C?

I have given server C 98% priority in backup preferences – AG.

Running below query on server C but it throwing 1 which means I can't take backup on that server.

SELECT sys.fn_hadr_backup_is_preferred_replica (‘dbname’);
GO
  • Why would you want to take backups of a potentially out-of-date database? Add more details about what you are attempting to do, and why. Use the edit button. – Max Vernon Jun 1 '16 at 19:25
  • we want to offload database backup which consumes I/O and CPU from prod primary server, is it possible to take backup on secondary? – Ashish Chauhan Jun 1 '16 at 21:26
  • is it possible to perform differential backup from primary and full and t-log from secondary in Always-On? Is there any data inconsistency issue while restoring these backups file? – Sam Jan 19 '17 at 20:58
1

I need to setup full-backup and diff backup. Can I do it on Server C?

You can do a copy only full, but unless C is the primary you cannot do a differential database backup.

Running below query on server C but it throwing 1 which means I can't take backup on that server.

A return value of 1 means it is "preferred" but doesn't necessarily mean you can run any type of backup on it.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.