Wednesday, March 7, 2012

Restore a single table

Hi,

I have a problem. For some reason I needed to restore a single (large) table that shares a filegroup with other tables. I have a full backup of the database. How can I restore my particular table?

-- Srinivas

Unfortunately this is not possible with builtin functions. There are onyl a few options. Restore the whole database to a new destination and copy the table to the final destination where you want to restore it. Use a third party tool which is able to extract only a single table from a backup media.

HTH, Jens Suessmeyer.

|||Thank you, Jens Suessmeyer.

No comments:

Post a Comment