• mahesh.dasoni (1/11/2013)


    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.

    i can smell that its again interview question ? anyways restore latest backup would be easier and appropriate approach here

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)