Post reply

backup

  • October 20, 2005 at 6:37 am

    #188131

    I took backup of the database and restored in some other location say mirror database.

    In the mirror database, I add some constraints by eliminating duplicates and foreign key constraints.

    In the meantime some data would have been updated or inserted inside the original database.

    How to identify the updated or inserted records without using triggers. I am also not allowed to add timestamp column to the structure.

    pls help me to solve this.

    thanks in advance

    regds

    vanitha

  • October 20, 2005 at 7:06 am

    #598679

    If you had installed a log viewing application (such as Lumigent's software), you could review the transaction log and see what changes were made.

    -SQLBill

  • October 20, 2005 at 7:23 am

    #598691

    is there any free 3rd party tool to do this?

    or any other method?

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply