I'm installing a highly critical system. If the system fails, the users wants data up to the last minute.
To achieve this, I was thinking of running Transaction Log Backups + FTP every minute. Has anybody done this before? Is this the best way to achieve the 1-minute data loss tolerance?
Appreciate any advice,