Post reply

Rollbacking changes by giving date as input

  • November 5, 2004 at 11:21 pm

    #102267

    Hi all

     I want to rollback the chages in my database by giving date as input.

    (ie) i need the last week data with discarding the changes done in this week  is it possible to do it in sql server 2000  ?

    pls help with ur suggestions

     

    Jones

  • November 7, 2004 at 8:56 am

    #529198

    If you have date feilds in your tables, you can delete based on dates, but you cannot "rollback" all changes based on a date with the SQL Server product.

    If you run log backups, Log PI, Lumigent Log Explorer or ApexSQL Log can help you.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • November 8, 2004 at 5:44 pm

    #529386

    I am NOT an expert.

    But you can try this.

    1. Do a transaction backup.

    2. Then do a restore of your database to the date that you want to roll back.

    3. Backup or copy out your database.

    4. Restore your database back to today.

    5. Delete all records.

    6. Copy back from your backup (from step 3)

    This will not work if you have primary keys etc etc.

  • November 8, 2004 at 9:23 pm

    #529396

    Hi Steve

           Thanks for the help . but all tables dont ve the date fields in my database . I ll try with ur other solutions

     

    ThanQ

    Cheers - Jones

  • November 8, 2004 at 9:27 pm

    #529397

    Hi Robert

     Happy to get help from u . I thank u  for the information . I ll do steps given by u .

     

    Thanks

    Jones

Viewing 5 posts - 1 through 4 (of 4 total)

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