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