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.

I have one primary database and it's getting replicated to another server. Both servers are SQL Server 2008 R2 with SP1. Replication was running fine till last week. We have transaction log backup every five minutes. I don't see any issue with log backup. Transactional Replication is setup as pull replication on secondary server. Distributor runs on secondary server. Everything was running fine till last week. This database is not mirrored. But cdc is enabled on the database. IsSyncWithBackup status is 0.

All of a sudden from last week, I see following message in last action column of Log Reader Agent even though replication monitor shows replication is in sync with no latency (??)

Replicated transactions are waiting for next Log backup or for mirroring partner to catch up.

@Kin, Sorry. This is the first time I am using stackexchange portal. For some reason, I am not able to add comments to your replies. So, I am editing original post based on replies I am getting.

@Mike, It showed REPLICATION for log_reuse_wait_desc for the database set up in replication.

As a last resort, we dropped the replication and we will recreate it after business hours today. As of now, this issue is resolved. Still not sure though what caused it in first place. Thank you all for your replies.

share|improve this question
    
Any chance you have mirroring enabled ? Also look at TF 1448. Also from the error, it is clear that you are using mirroring and your principal and mirror are not in sync. –  Kin Nov 18 '13 at 23:18
    
Also, for replication if sync with backup is true then you have to disable it on Publication database EXEC sp_replicationdboption 'PublisherDB','sync with backup',false. Refer to Enable Coordinated Backups for Transactional Replication –  Kin Nov 18 '13 at 23:26
1  
Can you run this query and share the results for log_reuse_wait_description for the particular database - select * from sys.databases –  Mike Walsh Nov 19 '13 at 1:45

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.