You must Sign In to post a response.
  • Category: SQL Server

    how to recover deleted table in sql database

    I wrongly drop the table with values.If any chance to recover the table please tell me.
  • #294775

    If it's in FULL recovery model, you can use the RESTORE LOG with the STOPAT clause and specify the time before the drop table command occurred.Otherwise, restore a backup of your database on a different instance or using a different name, script out the table creation and do a DTS package to import the records back. I am assuming you have no key issues here as you were able to drop the table successfully


  • #294778
    if you used this way

    drop table a

    then you rollback otherwise not,


    Thanks & Regards
    Patel Vipul

  • #294800
    Rollback the transactions

    Surely you will get the dropped table.

  • #295728,289483,sid87_gci1219179,00.html
    try this link

  • #296961
    here i am deleting one table how to recovery a table and
    how to rollback transaction ??

    delete from table

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.