Backup only one table

Hi
Does anyone know how to backup just one table (or selected tables) in
SQL2000?
Any help will be appreciated.
Thanks
CraigYou can't do that using BACKUP/RESTORE (well, you can put them on their own filegroups, but your
restore options are severely limited). How about using BCP/DTS etc ?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Craig Bryden" <craig@.ch.co.za> wrote in message news:Ozo3oFuaDHA.3444@.tk2msftngp13.phx.gbl...
> Hi
> Does anyone know how to backup just one table (or selected tables) in
> SQL2000?
> Any help will be appreciated.
> Thanks
> Craig
>