I am trying to set up log shipping to a database that will only be used for reporting, and am having trouble setting it up the way I want it. I want to backup and copy log files to the second server every 2 hours but only want the restores to occur once a day. I have set it up twice already and have modified the copy & restore start times and it has failed both times with this error:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4330: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.
If I have multiple transaction logs in the folder that need to be restored I get an additional error that "the log in this backup set is too late to apply to the database" (error 4305). So I temporarily moved them and this error goes away. I also can't find any helpful information about error 4330.
Do I need to set up log shipping to create only one log backup per day? Has anyone tried to do this before?