Backup Only One Table

  • Hello,

    I was told that I need to begin burning one database table to a CD. How do I go about doing this?

    Thanks,

    Melanie

  • You will need to export to another location such as another db, access db, excel or text file. You cannot just backup one table out of a database without backing up the whole DB unless you export a copy somewhere to work with.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Hello,

    Thank you for your response. I figured that I needed to export, but I was told that the table could be burned itself.

    Thank you very much.

  • Unfortunately as long as the table is part of the database file you cannot burn just it to disk. It will have to be copied to another file. If you need to do this on a regular occasion then consider using BCP or DTS, something you can schedule to have exported for you.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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