I am new in SQL Server and i don't have much space on our server drive that's why we don't want any huge log files and also we need log shipping for all the database.
We setup SQL Server 2014 Standard Edition on our server and shipping the logs to another server in every 15 minutes and also we have truncate the logs every midnight Sunday. Everything working fine for last six days and another day my logs shipping breaking with below error on primary end and on secondary server end-
1.- Error: BACKUP LOG cannot be performed because there is no current database backup. [whereas we have backup in the drive]
2. Error: This log cannot be restored because a gap in the log chain was created. Use more recent data backups to bridge the gap. [whereas log shipping for this database working properly ]
I think i am doing wrong truncate the logs and logshipping both can not work
Please suggest if i am doing wrong -