Replication Error Due To Log File Full

Creation date: 2/15/2024 9:25 PM    Updated: 2/15/2024 9:25 PM   #log file full #replication
Replication failed due to log file is full.



1st Step) Check the log files size for the publisher and subscriber to determinate which db is affected. Right click on the database and click Properties on SSMS

2nd Step) Click on Files and you can verify the current file size now


From the picture above, you can observe that the file size is approaching the limit already.

3rd Step) Click the Add button and you will have a new row created in the grid

Fill in the details accordingly, if the log file is full, choose the Log in the File Type column. After done, click OK. This will create a new log file. 

4th Step) Restart the MsSQL service and wait for 10 minutes to see whether records are synced over after that.