Post reply

restoring dropped table

  • October 18, 2007 at 10:54 pm

    #122043

    Hi ,

    Accidentally a script deleted certain tables in my sql server database.

    Is there any means by which I can restore the table data.

    I used the command "FLASHBACK TABLE tcm_counter TO BEFORE DROP"

    but it is not working out.

    Please help me in restoring the table.

  • October 18, 2007 at 11:19 pm

    #743405

    You can do flashback in Oracle, not sql.

    Restore your db to a copy - make sure you don't overwrite your mdf and ldf - from a backup that has the table you're after.

    Then create the table structure on your db (CREATE TABLE...)

    Then run INSERT INTO your_db.dbo.tblname SELECT * FROM copy_db.dbo.tblname

    Check and drop the copy_db.

    You restore from a backup only the whole db, not separate object within.

    Good luck

  • October 18, 2007 at 11:54 pm

    #743412

    The easiest way of restoring a database is by means of using database publishing wizard. The feature of using this wizard, is it will carry both schema & data of all the objects of a particular database. Provided, if you have the very latest script file of this, you can do so.

  • October 19, 2007 at 2:35 am

    #743464

    Hi ,

    Thanks for your reply .

    But I couldn't articulate the following line of yours.

    " Restore your db to a copy - make sure you don't overwrite your mdf and ldf - from a backup that has the table you're after. "

    I dont have any latest back up of my db..

    Is it possible to do something with the transaction log ..

    regards

    M.Malar.

  • October 19, 2007 at 3:43 am

    #743488

    Have a look at Red Gate's SQL Log Rescue. It will restore your table based on the transaction log and earlier backups. It is a free tool and it works with 2000 only.

    Disclaimer: I work for Red Gate, and I wrote the engine of the tool in question.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • October 23, 2007 at 6:58 am

    #744482

    Dear Andras,

    I have downloaded the tool. It works fine.

    Really such a nice tool and very user friendly also.

    So so thanks.

    I was able to recover certain tables but not all the tables .

    Anyhow thanks a lot.

  • October 23, 2007 at 7:00 am

    #744485

    Andras,

    I have downloaded the tool .

    It works fine.

    It is a very nice tool and very userfriendly.

    I could retrive certain tables but not all the tables.

    Anyhow thanks a lot for you ..

Viewing 7 posts - 1 through 6 (of 6 total)

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