<div>
<div class="content wysiwyg-content">
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. <br />
<br />
Thanks In Advance
</div>
</div>


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

SQL Server Log Shipping

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.