SQL Server Performance

How to recover deleted table?

Discussion in 'General Developer Questions' started by surendrakalekar, Nov 15, 2005.

  1. surendrakalekar New Member

    Is there any way to recover the table, which is got deleted?


    Surendra Kalekar

    surendrakalekar, Nov 15, 2005
    #2

  2. druer New Member

    You can restore from a backup to another location, then move just that table from the restore back to your primary server.

    It sounds like SQL Server 2005 has a really nice feature to selectively restore tables which sounds really cool. (As I've been in the same situation before when a senior developer deleted half of the data in our primary patient table thinking he was in the test environment.)
    druer, Nov 15, 2005
    #2

  3. ralph New Member

    Uh, isn't this dangerous? I know from DB/2 that they have things like 'on delete cascade' and though I don't know it I'd guess that SQL Server has something alike. So if one restores a single table I'd expect that one might lose data integrity.
    Wouldn't it be better (safer) to restore and roll forward?
    ralph, Nov 15, 2005
    #2

  4. Luis Martin Moderator

    If the table has not relations, you can restore from backup.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Nov 15, 2005
    #2

  5. FrankKalis Moderator

    I think tools like Log Explorer have also the ability to recover dropped tables. That of course implies, that they need to be installed on the system before the DROP happens. They are pretty much useless after the fact has occured. This might also be a good moment to think about your security and disaster recovery strategy.

    SQL Server also implements referential integrity, for example, via ON DELETE CASCADE. So, if you restore from a backup in a heavily used system, I would suspect you manually need to look for data integrity issues that are likely to be there.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
    FrankKalis, Nov 15, 2005
    #2

  6. Madhivanan Moderator

    If you think the data of particular table is more important then you can write Trigger so that the deleted records are stored in some audit tables

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Nov 15, 2005
    #2

  7. surendrakalekar New Member

    Thanks everybody


    Surendra Kalekar

    surendrakalekar, Nov 16, 2005
    #2

  8. nancy02 New Member

    Text edited
    *** SPAM and advertisement
    nancy02, Jul 27, 2011
    #8

  9. Luis Martin Moderator

    Well, this thread is 5 years old and sound Advertising....
    Luis Martin, Jul 27, 2011
    #9

  10. satya Moderator

    Why doubt...it is an advertisement...
    satya, Aug 3, 2011
    #10

  11. miteshaegis New Member

    Hi,

    Simple codefor recover deleted table

    SQL> drop table mytab;

    and check your table.


    thanks!
    miteshaegis, Nov 30, 2012
    #11

  12. FrankKalis Moderator

    Welcome to the forum!
    I'm not sure I understand your remark. Can you please explain?
    FrankKalis, Dec 2, 2012
    #12

Share This Page