Log Backup failed on Secondary Replica

• aroojsql

  Valued Member

  Points: 62

  More actions

  October 11, 2024 at 5:29 am

  #4467504

  I have a scenario where log backup is getting failed in Secondary replica on AlwaysOn availability group due to below error:

  "Log Backup for database  on a secondary replica failed because a synchronization point could not be established on the primary database. Either locks could not be acquired on the primary database or the database is not operating as part of the availability replica. Check the database status in the SQL Server error log of the server instance that is hosting the current primary replica. If the primary database is participating in the availability group, retry the operation"

  I have validated database is part of availability group and in healthy state. This is newly configured database and from beginning it's getting failed in secondary replica. As I compared in other instance as well and no issue found.

  Please help me on this to fix the issue.

  Note: After SQL Installation server is not yet rebooted . I am just suspecting this may be caused. Please correct me if am in right path.

   

  Thanks in advance!

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 12, 2024 at 6:10 am

  #4467866

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• keyurinbox

  Old Hand

  Points: 300

  More actions

  October 17, 2024 at 8:34 pm

  #4469720

  • is this a normal Availability group or a Distributed Availability group ?
  • The Backup preferences is secondary or primary?
  • How did you create the AG? Via the wizard or backup/restore on secondary?