Point in Time restore on a single table

[brutus6294]

Think I know the answer, but is it possible to do a "point-in-time" restore to an individual SQL table? Leave the rest of the database intact but restore a single table back to a certain point in time.(using SQL 2000).

I think the answer would be to restore the whole database to a new database and DTS the individual table over, but thought I'd ask anyway.. Thanks.

 

[ptheriault]

I think the answer would be to restore the whole database to a new database and DTS the individual table over, but thought I'd ask anyway.

That is the correct answer. However, I would caution you on this as well because you can orphan records or cause other problems with data integrity if the data in your table has FK's.

Also, There is a third party backup tool named litespeed. If you have backed up your database with that tool it is posible to do single table restores.



- Paul
- If at first you don't succeed, find out if the loser gets anything.