Post reply

Transaction Logs not being backed up on Availability Groups although flagged as successful

  • May 13, 2014 at 2:38 am

    #286610

    Hello,

    Just wondering if someone can help me here, we use AlwaysOn availability groups, which has 2 SQL nodes configured (version: 11.0.3373.0), my full and differential backups are working for all my databases, however I am unable to perform any LOG backups.

    I have double checked my Availability Group settings, and the backup preferences is set to: 'Prefer Secondary'

    I've tried creating a maintenance job as well as using Ola Hallengren's maintenancescript job to back them up, but nothing is written to the drive. All jobs return successful every time, and take less then 3 seconds to run. There are no events being written in the SQL error log or event log.

    Any suggestions?

    Marcus

  • May 14, 2014 at 9:46 am

    #1713533

    Hi,

    Just an update to everyone, I have resolved this issue by updating my SQL from 2012 SP1 CU5 up to CU9. All log backups are now working. Not sure what the actual resolution was, but hey its working now.

    Marcus

  • May 15, 2014 at 3:08 am

    #1713740

    Thanks for letting us know!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply