June 14, 2015 at 10:12 pm
I am getting the error The transaction log for database 'ReplicationDB' is full due to 'LOG_BACKUP'.
log_reuse_wait_desc from sys.databases is showing logbackup
The database is subscribed database. We configured transactional replication. But the transactional replication is getting errors and failed. Is there relation b/n this replication failures and log growth in subscriber db?
June 15, 2015 at 3:04 am
Have you configured Database Mirroring along with this !
I used to get this error before in one of our database where we configured Database Mirroring and Transaction Replication before.
I did not remember the workaround , but if you want to try on your production database , try this the following two suggestion.
EXEC sp_replicationdboption 'PublisherDB','sync with backup',false
Enable trace flag 1448
June 15, 2015 at 8:57 am
We didn't configured for mirroring. Only transactional Replication setup
June 15, 2015 at 4:20 pm
Is the DB in full recovery mode ? Are you taking log backups ?
Cheers
Vultar
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply