Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In case of async commit setup and the backup preference set to secondary replica. I have observed, in case of high unsent log size, log backup on secondary replica starts failing for that database with error:

Connection With Primary Replica Not Active

The unsent log size was ~4GB. There was no connectivity issues.

What factors impact log backups in multiple secondaries and async commit mode?

share|improve this question
1  
Which DBMS and/or tool(s) are you using that give you this error? This question is pretty meaningless without that information. –  Colin 't Hart Feb 27 at 9:22
    
This is the error we get in SSMS, with the normal backup command. BAckup log <dbname> to disk = '<path>' –  user34707 Feb 27 at 10:45
    
What is SSMS? Please update your question to include name of DBMS and tool and tag for them too. –  Colin 't Hart Feb 27 at 10:49
    
You need to first verify that your secondary replica is in a SYNCHRONIZING state. –  Thomas Stringer Mar 7 at 19:07
add comment

1 Answer 1

You can backup on any secondary replica if they are connected to the primary replica AND the state is either SYNCHRONIZED or SYNCHRONIZING.

It seems that you should check the connection to the primary replica. Please take a look in the sql server's error log.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.