Post reply

restoring a single table from the backup

  • May 3, 2009 at 5:37 am

    #208951

    hi all,

    is there a way we can restore a single table from the backup?

    i heard lightspeed enterprise version supports object level recovery but not sure if it handles all the Foreign keys relationship properly..

    thanks in advance!!!!.

    thanks

    om.

  • May 3, 2009 at 6:21 am

    #987814

    Not using native tools, no.

    Basically if you want a table, you have to restore the DB elsewhere and then extract the table.

    Litespeed allows you to recover a table from a backup, and you have to put it into some DB. I don't think it does put the foreign keys on (or it might be an option) because you can use that to restore the table to a completely different DB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 3, 2009 at 12:03 pm

    #987835

    hey...thanks alot for the info.

    lightspeed always creates a new table when restoring tables, it never overwrites the existing table.

  • May 4, 2009 at 2:06 pm

    #988357

    It would be very nice if MS introduced this concept sometime down the line. Litespeed does allow object restore but if you use TSM style backups like we do that does not work.

  • May 6, 2009 at 11:33 am

    #989767

    Full Disclosure: I work for Red Gate

    You can restore single tables from native SQL Server backups using SQL Compare Pro and SQL Data Compare Pro. With SQL Data Compare you can even restore individual rows from a backup into an existing table. The handling of foreign keys depends on precisely what you are looking to do, the simplest would probably be to grab a trial copy from http://www.red-gate.com and give it a go.

    Theo

  • May 10, 2009 at 12:43 pm

    #991817

    k.omprakash26 (5/3/2009)

    hi all,

    is there a way we can restore a single table from the backup?

    i heard lightspeed enterprise version supports object level recovery but not sure if it handles all the Foreign keys relationship properly..

    thanks in advance!!!!.

    thanks

    om.

    You can think of granular backups like filegroup backups and restore them. Create your objects in the filwgoup you have created, back it up and restore filegroups when needed.

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

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