Backing up Tables

Hi
Is there a way to backup many tables in a SQL Server database to a text
file all at once? I know this can be done individually using the
import/export wizard, but I have many tables that need to be backed up
often and still have the ability to restore them all at once as well.
Basically we use 1 database for many tests and after each test we want
to backup the data in certain tables, not backup the entire database.
Thanks
Laura
You could move all of the tables that you wish to back up, including their
indexes, into a secondary file, in a secondary filegroup. You could then
backup only that filegroup.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
<Laura.X.Kennedy@.JPMorgan.com> wrote in message
news:1166478797.830720.145090@.79g2000cws.googlegro ups.com...
> Hi
> Is there a way to backup many tables in a SQL Server database to a text
> file all at once? I know this can be done individually using the
> import/export wizard, but I have many tables that need to be backed up
> often and still have the ability to restore them all at once as well.
> Basically we use 1 database for many tests and after each test we want
> to backup the data in certain tables, not backup the entire database.
> Thanks
> Laura
>
|||DTS?
<Laura.X.Kennedy@.JPMorgan.com> wrote in message
news:1166478797.830720.145090@.79g2000cws.googlegro ups.com...
> Hi
> Is there a way to backup many tables in a SQL Server database to a text
> file all at once? I know this can be done individually using the
> import/export wizard, but I have many tables that need to be backed up
> often and still have the ability to restore them all at once as well.
> Basically we use 1 database for many tests and after each test we want
> to backup the data in certain tables, not backup the entire database.
> Thanks
> Laura
>