Database Backup & Restore

Most of the rows in one of the tables in our database were deleted by a DTS
package. (The DTS package does a complete replacement of the table.
Unfortunately the source is a "work" file which had been cleared.) I ended
up restoring the last backup of the database with a different name and then
copied the data from the alternate DB. But I was wondering, is it possible
to restore a single table in a database from a full database backup or can
you only restore the entire database?
Not with the native Sql Server backup and restore commands. There are some
third party products who claim to have object level restore capabilities but
I have not tried any of them. It can be a very dangerous thing and must be
done considering all the elements so you maintain your data integrity.
Andrew J. Kelly SQL MVP
"Evan Nelson" <EvanNelson@.discussions.microsoft.com> wrote in message
news:BBEB73EC-AB2B-48F5-92D8-AAAF056EE80C@.microsoft.com...
> Most of the rows in one of the tables in our database were deleted by a
> DTS
> package. (The DTS package does a complete replacement of the table.
> Unfortunately the source is a "work" file which had been cleared.) I
> ended
> up restoring the last backup of the database with a different name and
> then
> copied the data from the alternate DB. But I was wondering, is it
> possible
> to restore a single table in a database from a full database backup or can
> you only restore the entire database?