How do I restore only one table in SQL2000?

Discussion in 'Databases' started by steldingc, Sep 27, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. steldingc

    steldingc

    Weneed to restore just one table, and not the entire database to the current one. We had a SQL insertion which corrupted that table. Fortunately we had a .bak made and we can restore the entire database. But that restoration will overwrite the other tables, which will destroy current data in them. We just need torestore the one which is notrelated to any other tables. Any ideas?
     
    steldingc, Sep 27, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    You cannot restore just 1 table.


    What you can do is


    1) Restore you bak file into another database


    2) Use DTS to copy that table over to the server.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Oct 2, 2007
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page