Changing Availability Group

  • Hi Experts,

    How can we change the backup replica in Always on Cluster. I am not able to take backup because of this.

  • 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" 😉

  • 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

  • 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.

  • Thanks Perry and SQLGuru for the reply

  • 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" 😉

  • 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.

  • 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