June 19, 2012 at 5:39 am
I have SQL Server 2008 transactional replication for 21 locations.No Mirroring is configured on this server for any database yet I am getting the error:
Replicated transactions are waiting for next Log backup or for mirroring partner to catch up
Due to this without taking log backup the the log reader shows this above error and replication is not continued
Thanks
June 19, 2012 at 5:55 am
Does the system table below show entry of some old mirroring set up which was removed later
select * from sys.database_mirroring
If this is has some entries of mirrored database please break the mirroring if you are not using it.
Cheer Satish 🙂
June 19, 2012 at 6:02 am
I have checked from GUI and :
Select * from sys.database_mirroring_endpoints;
and find nothing.
That server is never used for mirroring also.
It is production and needs lots of approval for any change.
Thanks
June 22, 2012 at 1:03 am
Hi,
After enabling trace 1448 the issue has not resolved.
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply