Post reply

Restoring Dropped Tables

  • March 25, 2008 at 7:51 am

    #121082

    Hi!

    We are currently on our testing of our project. and unfortunately, I have dropped tables:w00t:. Included in those dropped table will be used as reference table of our project.

    Anyone can help? is there any way I can restore those tables and its data? or at least its structure. we are using MSSQL Server 2000 also im not a dba, that's why i don't know whether i posted it on the right topic

    thanks.

  • March 25, 2008 at 7:54 am

    #793497

    You can restore it if you ahve a log backup or full backup before you dropped the tables.

  • March 25, 2008 at 8:37 am

    #793532

    You can restore it through the last backup taken by the DBA or the DB engine.

  • March 25, 2008 at 6:00 pm

    #793801

    thanks pmohan and Ambuj Mathur.

    Please correct me if I'm wrong, I believe backup contains the entire database. Can I restore selected tables only?

  • March 25, 2008 at 6:37 pm

    #793813

    Restore the backup and transaction log backup if needed to a NEW database, either on the same server or another server.

    Then you can use either DTS to transfer the dropped table to the original database, or re-create the table using script from the restored database, and load the data from back.

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

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