Post reply

DB Backup

  • March 12, 2004 at 7:01 am

    #84249

    Hey guys,

    I'm kinda new to SQL Server 2000 and want to know on a database backup, how do I only do a backup/restore on tables.  I don't want to do a full backup I just want the table data.  All the help is appreciated.

    Thanks

  • March 15, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 22, 2004 at 5:18 am

    #499726

    You cannot do inidividual object backup/recovery in sql 2000.

    You need to take full backups.

  • November 27, 2008 at 11:21 am

    #904443

    We can't take a backup for for particular table.

    If you want just copy and store it into the other database by using export or import

  • November 27, 2008 at 11:34 am

    #904445

    I think you can do that... here's something you can try and test out for yourself (and let us know if it works).

    Create a new filegroup.

    Move the table to that filegroup (create clustered index on the new filegroup using the drop existing option)

    Then take a backup of the filegroup.

    To test... restore that filegroup on another db (or using a test db as guinee pig), and see what happens. I'm sure there's something else invovled there, that just seems too easy ;).

    P.S. Make sure you change something in the DB after you take the backup... that way you'll know if it did work.

    Let us know how that worked for you... I'm curious to see how you can do that.

  • November 27, 2008 at 12:17 pm

    #904459

    Um... Did anyone notice that this thread is 4 and a half years old, and was answered accurately 10 days after it was posted?

    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

  • November 28, 2008 at 4:08 am

    #904668

    Not really, but it doesn't matter since any one can use google to find this thread again, so any new info is still usefull to post!

  • November 28, 2008 at 4:35 am

    #904691

    Ninja's_RGR'us (11/28/2008)

    Not really, but it doesn't matter since any one can use google to find this thread again, so any new info is still usefull to post!

    My comments was more directed to Lee. Thread necromancy...

    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

  • November 28, 2008 at 4:37 am

    #904696

    A thread is never dead on the internet....

    also I'd rather welcome him to the stie and congratulate him for his first post ;).

Viewing 9 posts - 1 through 8 (of 8 total)

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