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
3
  • 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.
    – Hannah Vernon
    Jun 1, 2016 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? Jun 1, 2016 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, 2017 at 20:58

1 Answer 1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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