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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy