Home Forums SQL Server 2008 SQL Server 2008 High Availability Confusion regarding which full-backup file to apply on secondary in Log shipping RE: Confusion regarding which full-backup file to apply on secondary in Log shipping
SqlSWAT
Ten Centuries
Points: 1200
More actions
February 28, 2013 at 10:47 am
#1592105
Hi Anoop,
The Full Database backup taken on 28th is sufficient enough and have all the transaction changes till the 28th. You can apply the 28th full backup and all the Transactional log backups(.trn) after that to bring the Secondary back In-Sync.