Post reply

Single Table Restore SQL 2000

  • September 7, 2006 at 11:05 am

    #119447

    Hi all;

    I need to restore a single table back to one on my databases. I do have a complete backup (*.BAK) and subsequent transaction log files.

    Does anyone have "practical" implementation in restoring of a table, or the complete database? Are there any good FAQ's in the restore procedures?

    Thanks,

    Steve

  • September 7, 2006 at 11:22 am

    #659170

    Can't do it. (Not really). The only solution I know of is to restore the database to another instance (or to another name) and then import just that table.

    -SQLBill

  • September 7, 2006 at 2:45 pm

    #659211

    As SQLBill says, you can't restore a single object directly into a database.  See "How to restore a database with a new name" in BOL.

    Greg

    Greg

  • September 7, 2006 at 10:02 pm

    #659255

    you can do a single table restore if that table resides on its own "file group". Else you would have to restore and copy over.

    Thanks

    Sreejith

  • June 11, 2009 at 12:19 pm

    #1008185

    Hi

    it is possible using restore option in SQL SERVER 2000 only .......

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

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