Backup Restore Tables inside a database

Can back up and restore a complete database, but it appears that I do not
have the options to restore individual tables inside the database. Is there
a way to restore at the table level?
Thanks,
KeithYou can't restore an individual table with SQL Server 7 or
SQL Server 2000. You would need to restore the backup to
another server or database and then copy the table from the
restored database.
-Sue
On Tue, 1 Mar 2005 17:01:02 -0800, "Keith"
<Keith@.discussions.microsoft.com> wrote:

>Can back up and restore a complete database, but it appears that I do not
>have the options to restore individual tables inside the database. Is ther
e
>a way to restore at the table level?
>
>Thanks,
>Keith|||This is useful when you have a lot of data in your table. To do this your
database should be organized in primary and secondary filegroups. The large
tables should be on their own filegroup. In such cases you can backup and
restore a single file group (+ primary) and this way you may get just the
table you need.
Look for "Partial Database Restore Operations" in books online
Arun
"Keith" wrote:

> Can back up and restore a complete database, but it appears that I do not
> have the options to restore individual tables inside the database. Is the
re
> a way to restore at the table level?
>
> Thanks,
> Keith
>sql