Log Shipping Restore full only if not yet restored

Is it possible to restore a database only if it has not been restored? Using LATEST_ ALL will always restore the full, using LATEST_DIFF assumes that there was a FULL restore already. I want a 1 off command that only restores FULL if not already restored and only DIFFs that are not already restored. Thanks
Tagged:

Best Answer

  • Eddie DEddie D Posts: 1,497 Rose Gold 3
    Accepted Answer
    Hi, thank you for your forum post.

    The LATEST_ALL keyword will restore both the latest Full backup followed by the Latest Differential backup (if the Full Backup restore is successful).

    The LATEST_DIFF keyword will simply restore the latest differential backup you must restore the most recent Full backup prior to running the restore using this keyword.

    There is also a LATEST_FULL keyword which will restore the latest full backup.

    There is not a command or keyword available that will perform the following actions:
    1 off command that only restores FULL if not already restored and only DIFFs that are not already restored. 

    Many Thanks
    Eddie


    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.