We are in a situation to sync databases between two servers settings in a totally different domain . The app team have provided FTP location to copy the backups and the requirement is to sync the secondary every 15 minutes.
I tried creating copy only log backup every 15 minutes copied the backup to secondary and restore manually keeping the secondary in Standby Mode.
The Primary database have Regular Daily Full Backup, One hour Differential and 20 minutes log backup. The Copy Only restoration fails with error the LSN is recent. What might be going wrong? My understanding was that the COPY_ONLY is not affected by regular backups and the LSN break wont happen.
Can anyone help me achieve this task?
Automatic restoration every 15 minutes is another hurdle :-(.