InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 00:21:28 GMT20http://www.sqlservercentral.com/Forums/Topic1405795-1549-1.aspxOpc is right about the differential backup. About restoring the full backup. If the size of the DB is big and if you have all transaction logs I will probably copy all the transaction logs and start the restore job. If restoring the differential is an option I'll will chose that one for sure.Sun, 20 Jan 2013 14:45:03 GMTIgnacio A. Salom Rangelhttp://www.sqlservercentral.com/Forums/Topic1405795-1549-1.aspxIf you have not taken a full backup on the primary since log shipping became out-of-sync then you can bring the secondary up to date and resuming the existing log shipping configuration by taking a differential backup from the primary and restoring it on the secondary. If you have taken a full backup from the primary since log shipping went out-of-sync then you will need to re-initialize log shipping from a full backup.Fri, 11 Jan 2013 06:49:03 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1405795-1549-1.aspx[quote][b]mahesh.dasoni (1/11/2013)[/b][hr]Logshipping is out of sync for 2 days and so i have a huge amount of logfiles to copy and restore to DR Server.Is there any way by which i can reduce my time of restoring all these logfiles and instead do something by which my logshipping can start without restoring all the logfiles one by one.[/quote] i can smell that its again interview question ? anyways restore latest backup would be easier and appropriate approach hereFri, 11 Jan 2013 01:28:47 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1405795-1549-1.aspxHow often do you do FULL backups?Fri, 11 Jan 2013 01:24:23 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1405795-1549-1.aspxLogshipping is out of sync for 2 days and so i have a huge amount of logfiles to copy and restore to DR Server.Is there any way by which i can reduce my time of restoring all these logfiles and instead do something by which my logshipping can start without restoring all the logfiles one by one.Fri, 11 Jan 2013 01:10:05 GMTmahesh.dasoni