Post reply

How to recover deleted rows --Help

  • May 31, 2004 at 11:35 am

    #84588

    Hi

    i have deleted some rows from production db by mistake ,kindly suggest any way to recover that ,,,,,,,,,,,,,,,,,,,,,,,

    Thanks

  • May 31, 2004 at 12:55 pm

    #508433

    You have to recover your database from your last backup possibly on another instance, apply your transaction log just before the deletion, and you'll now be able to recover your deleted rows in your production database.

    I hope it's clear.

    Good luck.

    Denis Desjardins

  • May 31, 2004 at 3:34 pm

    #508435

    You are in soup, aren't you ?

    If you are lucky enough you should have log backups, and as mentioned above you will be able to get things back.

    If you don't have log backups then unfortunatlly there isn't much you can do.

    You can try "Lumigent log explorer" which allows you to rollback single operations or transactions. It's a great product. Try it :

    http://www.lumigent.com/products/le_sql/le_sql.htm

     

    Regards.

     

  • May 31, 2004 at 10:50 pm

    #508451

    thanks but i dont have transactional backup so it  means there is no possibility to get back my data.

    Thanks

  • June 1, 2004 at 6:59 am

    #508491

    If you have a recent Full Backup which contains the data then you can also restore it under a different instance and pull the data out.

  • June 1, 2004 at 8:01 am

    #508505

    what cpruden  means that

    1- you can make the a new db in another server with the  same name (and this DB is empty .. even with no tables)

    2- restore you backup over it

    3- copy the rows you want from here and put it in your table

    I hope this help u


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • June 1, 2004 at 10:10 am

    #508529

    thanks but my concern is that i dont have any backup for those deleted rows,so please suggest is there anyway to recover the deleted rows without any type of backup.

    thanks

  • June 1, 2004 at 10:22 am

    #508530

    There is no way to recover deleted rows from a database without a recent backup and/or transaction logs. If you have current transaction logs then may be Lumigent log explorer from an earlier post could help.

  • June 1, 2004 at 11:04 am

    #508536

    Do you have a full backup?

    If so, RIGHT NOW, backup your transaction log. Immediately. The transaction log backup will have everything that occured including the delete.

    Now you have a full backup and at least one transaction log backup. Do you have any other transacation log backups since your full backup? (I'm guessing you don't).

    Now you can do two things.

    1. Restore the Full backup (using WITH NORECOVERY) to a new instance. Then restore the Transaction Log backup (using WITH RECOVERY, STOPAT <date/time&gt. For the transaction log recovery, use a date/time prior to when the delete happened. That will restore the database to the way it was prior to the delete. Then compare that database to the real one and make any needed changes/updates.

    2. Just restore the Full and Transaction logs over the current database using the WITH STOPAT on the transaction log recovery. That will put the database back to the way it was before the delete, but you will have lost everything since that happened.

    GOOD LUCK.

    -SQLBill

  • June 1, 2004 at 11:05 am

    #508537

    BTW- Do a TRANSACTION LOG backup NOT a FULL Backup. Do a full one and you'll lose the chance to recover the data.

    See the Books OnLine for BACKUP LOG commands.

    -SQLBill

  • June 2, 2004 at 1:14 am

    #508585

    if you don't have any bakcup .. you can't get data back...except you get an log explorer program to see your log .. and this is the last chance for you. (note don't make full backup .. because you will los what in your Log file)

    from now on .. you have to make Backup .. the standard steps is as follow:

    1- Make full backup daily

    2- make Log backup every hour (or every 30 minutes)

    I hope this help u


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • June 3, 2004 at 8:27 am

    #508844

     

    Did you find a way out ..........

     

    Michael

Viewing 12 posts - 1 through 11 (of 11 total)

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