Backup and Restore


  • SQL Server 2008 R2

    Hi guys, I am new in replication and learning/testing <Back and Restore> procedures.

    I am following the TechNet article:

    Strategies for Backing Up and Restoring Snapshot and Transactional Replication 

    I have doubt over restoring the Subscription database:

    In the Technet article is written:


    Is the latest subscription database backup more recent than the maximum distribution retention setting on the distribution database? (This determines whether the Distributor still has all the commands that are required to bring the Subscriber up-to-date.) If yes, go to step 2. If no, reinitialize the subscription. Recovery is completed.


    Form my side I need more clarification about:

    Is the latest subscription database backup more recent .....

    My question is:

    How can I calculate the last backup time (It is not clear how can I calculate the time for the last backup) to be compared with the distribution retention time?

    Many thanks for you help

    • Edited by fasttrack Thursday, February 23, 2012 11:23 AM
    Thursday, February 23, 2012 11:04 AM


All replies