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,805 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.