• You can query msdb to see the backups available for a database.

    I had written a script long back for the same

    http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/67296/

    The data is not synch because you have not applied all the backups or your backups are old

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]