I'm trying to setup an environment where I can restore log files from a primary database to a secondary database (different servers) every 30 minutes. I do not want to have to restore a full backup each time. This secondary database will be used as a read-only instances as well. At this point I'm getting an error "The log or differential backup cannot be restored because no files are ready to rollforward." I understand that this is maybe because the database is in recovery mode at the time.
Any help would be greatly appreciated.
Oh, the SQL Versions are both 2016.