I have restored my full backup on the secondary in norecovery mode and am now restoring about 100 or so T-Log backups in norecovery mode. My question is when I get to the last Transaction log can I restore the last log in Standby mode. Then let the Log Shipping jobs take over. Or should I have restored the Full backup in Standby mode from the start and not with NoRecovery.
Thanks In Advance