Backup a single table?

In SQL 6.5 you could backup a single table in a db to a
backupdevice or a file. I can not find this in the newer
versions SQL 7.0 and SQL 2000. Is this feature removed?
I know that the command has changed from DUMP to BACKUP
and that you nowadays often backup db-files or filegroups
instead.
This feature has been removed with SQL2000
"Stefan" <stefan@.discussions.microsoft.com> wrote in message
news:033c01c4b815$4a8a0600$a601280a@.phx.gbl...
> In SQL 6.5 you could backup a single table in a db to a
> backupdevice or a file. I can not find this in the newer
> versions SQL 7.0 and SQL 2000. Is this feature removed?
> I know that the command has changed from DUMP to BACKUP
> and that you nowadays often backup db-files or filegroups
> instead.
>
|||> I know that the command has changed from DUMP to BACKUP
> and that you nowadays often backup db-files or filegroups
> instead.
You will have to either (a) put it onto its own filegroup and backup the
filegroup, or (b) DTS a copy into an empty database and backup that
database.
http://www.aspfaq.com/
(Reverse address to reply.)