November 28, 2013 at 1:00 am
Hello,
quick question.
For example my AG consists of two instances that are set up with synchronous data movement. Also the readable secondary option is set to NO for both instances.
Backup preferences are default: Prefer Secondary - Will backup on secondary with highest priority.
Once i have my backup preferences and priority established, i am gonna to set up
a SQL Server Agent Job to perform the backups on each instance.
will it work? does readable secondary option impact on backup ability?
does it impact on result of sys.fn_hadr_backup_is_preferred_replica function?
November 29, 2013 at 1:08 am
Comeon! Anybody played with this option?
November 29, 2013 at 4:37 am
den_sidr (11/28/2013)
Hello,quick question.
For example my AG consists of two instances that are set up with synchronous data movement. Also the readable secondary option is set to NO for both instances.
Backup preferences are default: Prefer Secondary - Will backup on secondary with highest priority.
Once i have my backup preferences and priority established, i am gonna to set up
a SQL Server Agent Job to perform the backups on each instance.
will it work? does readable secondary option impact on backup ability?
does it impact on result of sys.fn_hadr_backup_is_preferred_replica function?
When perfoming a full backup on a secondary you can only perfom a copy only backup.
The way I set it up was the same backup job all all servers participating in the group. Within the job I use the code
IF sys.sys.fn_hadr_backup_is_preferred_replica function = 1
BACKUP DATABASE X TO ......
The function only returns 1 if the server you are running the command on is the perfered server for backups depending on the settings for your group and the priority of the server.
there is a full msdn article dedicated to this very subject.
MCITP SQL 2005, MCSA SQL 2012
November 29, 2013 at 4:45 am
Here is the msdn article:
http://technet.microsoft.com/en-us/library/hh710053.aspx
MCITP SQL 2005, MCSA SQL 2012
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply