Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changing Availability Group Expand / Collapse
Author
Message
Posted Tuesday, May 6, 2014 8:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 23, 2014 6:48 AM
Points: 2,633, Visits: 3,977
Hi Experts,

How can we change the backup replica in Always on Cluster. I am not able to take backup because of this.
Post #1567984
Posted Tuesday, May 6, 2014 9:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:17 PM
Points: 6,490, Visits: 13,968
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"
Post #1568018
Posted Tuesday, May 6, 2014 10:37 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 4,406, Visits: 6,270
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 at GMail
Post #1568084
Posted Wednesday, May 7, 2014 5:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 23, 2014 6:48 AM
Points: 2,633, Visits: 3,977
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.
Post #1568381
Posted Wednesday, May 7, 2014 5:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 23, 2014 6:48 AM
Points: 2,633, Visits: 3,977
Thanks Perry and SQLGuru for the reply
Post #1568382
Posted Wednesday, May 7, 2014 5:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:17 PM
Points: 6,490, Visits: 13,968
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"
Post #1568385
Posted Wednesday, May 7, 2014 8:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 23, 2014 6:48 AM
Points: 2,633, Visits: 3,977
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.
Post #1568494
Posted Wednesday, May 7, 2014 9:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:17 PM
Points: 6,490, Visits: 13,968
What error or messages were you receiving?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1568547
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse