• Are you trying to restore the database over the LIVE or restore to a point in time ( from a backup )to a different database so you can do some comparison ?

    You may wish to consider restoring the database to a separate database so that you can do specific table updates from the changed data ?!

    The other question is ... what is your backup plan ?

    do you have Full Backup and then T-Log backups ?

    So many questions - but it is important to know what you are doing and what the un-expected results could be and damage that could be done.

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.