Backup and Restore a Table

  • How can I take backup/restore of a perticular table from my database?

    Deepak

  • Backup and restore is done at the database level, or at the file group level - so if you put your table in separate file group you could achieve your goal that way. I don't use filegroups, so in my case I'd backup the entire db, then to restore a table I would restore the backup to a NEW db, then DTS the table over to the original db.

    Andy

  • That was one of the best/simple solutions I have read on this website to date. I am still an entry level DBA, and your discussion pointed me in the exact direction I needed to be.

    Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

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