Regarding, which transaction log restore after full restore
I have face problem when try to restore transaction log,
Suppose we have two DB servers : SERVER-A and SERVER-B
Database is PayrollDB on SERVER-A, which we want to logshipping on SERVER-B.
We have full back at 3:45 AM every day for PayrollDB on SERVER-A.
And transaction log backup every 10 minutes for every day for entire day.
Our last SERVER-AÃ¢â‚¬â„¢s PayrollDB full back up start at 3:45 am and completed at 4:08 am (took around 23 min for full backup).
As transaction log backup at every 10 min , we have transaction log backup at 3:40 am, 3:50 am, 4:00 am, 4:10 am , 4:20 am ,4:30 am , 12:30 pm , 1:00 pm and for entire day.
For Start log shipping , I restore SERVER-AÃ¢â‚¬â„¢s PayrollDB with Ã¢â‚¬Å“Non-operational (RESTORE WITH NORECOVERY)Ã¢â‚¬