Backup of Sql tables

I am a serious newbie. How do you backup only certain
tables in a database? Thank you.
Angela
There is no way to backup a set of files on a databases, unless these files
are on a different filegroup. So if you really want to do this you will
need a secondary filegroup where either the primary or secondary filegroup
contains the subset of tables you want to backup.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela
|||You export them. Using DTS, BCP or some other export method.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela
|||Thank you so much Tibor. That's what I thought but was
not sure. I will practice doing that and restoring
somewhere else to be sure. Thanks.
Angel

>--Original Message--
>You export them. Using DTS, BCP or some other export
method.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Angella Bennet" <anonymous@.discussions.microsoft.com>
wrote in message
>news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
>
>.
>