Post reply

Backup one particular table

  • September 23, 2008 at 12:52 pm

    #382788

    Hi,

    Is it possible to backup a particular table. truncate the table and if required, then restore the contents of the backed up table again?

  • September 23, 2008 at 1:32 pm

    #875992

    At this point the only way to do that, unless you are using partitioning, would be to do take a backup of your database (db1) and restore it to a new database (db2). From there you could then recover your data from db2 if need be to load back into db1.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 23, 2008 at 1:33 pm

    #875993

    Not through a "backup" process, but you can write a simple script to copy the table to a new table, truncate the old table, and copy the data back in.

  • September 23, 2008 at 1:34 pm

    #875995

    Not using the native backup tools.

    You can always bcp the table out, or make a copy of it in another DB with select .. into

    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

  • September 24, 2008 at 2:15 pm

    #876671

    I did this before using DTS package that was simple to do except I forgot to copy the keys and indexes.

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

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