May 6, 2014 at 8:32 am
Hi Experts,
How can we change the backup replica in Always on Cluster. I am not able to take backup because of this.
May 6, 2014 at 9:05 am
Ratheesh.K.Nair (5/6/2014)
Hi Experts,How can we change the backup replica in Always on Cluster.
I'm assuming you mean AlwaysOn availability group?
What are the current backup settings you have defined for your AlwaysOn group?
Ratheesh.K.Nair (5/6/2014)
I am not able to take backup because of this.
What issues are you facing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2014 at 10:37 am
Try here and associated links from this page: http://msdn.microsoft.com/en-us/library/hh710053.aspx
Also, SQL Server 2012 Books Online is your friend!!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 7, 2014 at 5:05 am
Perry Whittle (5/6/2014)
Ratheesh.K.Nair (5/6/2014)
Hi Experts,How can we change the backup replica in Always on Cluster.
I'm assuming you mean AlwaysOn availability group?
What are the current backup settings you have defined for your AlwaysOn group?
Ratheesh.K.Nair (5/6/2014)
I am not able to take backup because of this.What issues are you facing?
You are right its AlwaysOn. they backup is preferred to secondary at present..
Not able to complete the transaction log backup using maintenance plan in principle as it is checking this.
May 7, 2014 at 5:05 am
Thanks Perry and SQLGuru for the reply
May 7, 2014 at 5:18 am
Ratheesh.K.Nair (5/7/2014)
they backup is preferred to secondary at present..
This is the default option and backups will occur on a secondary unless the Primary is the only replica online.
Ratheesh.K.Nair (5/7/2014)
Not able to complete the transaction log backup using maintenance plan in principle as it is checking this.
Technet, AlwaysOn backups on active secondaries
Backup Types Supported on Secondary Replicas--------------------------------------------------------------------------------
•BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it is executed on secondary replicas. Note that copy-only backups do not impact the log chain or clear the differential bitmap.
•Differential backups are not supported on secondary replicas.
•BACKUP LOG supports only regular log backups (the COPY_ONLY option is not supported for log backups on secondary replicas).
A consistent log chain is ensured across log backups taken on any of the replicas (primary or secondary), irrespective of their availability mode (synchronous-commit or asynchronous-commit).
•To back up a secondary database, a secondary replica must be able to communicate with the primary replica and must be SYNCHRONIZED or SYNCHRONIZING.
What is the issue you are facing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2014 at 8:15 am
Thanks perry for the reply.
I was not able to take the log backup of primary ,changed the backup option(specified primary in backup preferences,Thanks to SQLGuru for sharing the link ) and now its working fine.
May 7, 2014 at 9:36 am
What error or messages were you receiving?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply