Database Backup & Restore

11 Feb 2005 5:37 PM

Evan Nelson

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?

11 Feb 2005 6:28 PM

Andrew J. Kelly

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

Show quoteHide quote

"Evan Nelson" <EvanNel***@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?