Post reply

how to restore just the table from full backup

  • September 21, 2005 at 9:45 am

    #110471

    one of my db table jus got corrupted.  is it possible to restore just the table from full backup?

  • September 21, 2005 at 9:58 am

    #591860

    Restore the db to a different dbName or different server, and dts it over.

    drop table in original db,

    dts data into original db from old db would be easiest.

     

  • September 21, 2005 at 10:48 am

    #591900

    That's the only way in 7 or 2000. SQL 6.5 had a table restore.

  • September 21, 2005 at 11:49 am

    #591934

    Thanks for your help.

  • September 22, 2005 at 8:02 am

    #592215

    You could use a third party tool which supports object level recovery.  Usefull if the table that needs to be restored is part of a very large database.  

     

  • September 22, 2005 at 9:00 am

    #592256

    Lumigent and a few other products can do this, assuming your database is full recovery and you have log backups or active log file from the time of the corruption.

  • September 23, 2005 at 8:03 am

    #592617

    I have used LiteSpeed from Imceda in the past and it works great

Viewing 7 posts - 1 through 6 (of 6 total)

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