Restore individual tables

[LouBurgoyne]

I have data in relatively static table. I have found that it has been inadvertantly deleted. The problem is that it appears to have been deleted some time ago (10 days).

What I want to do is take an existing historical backup and restore only the affected tabel, not the entire database.

Any help would be greatly appreciated.
Lou Burgoyne
Applications Administrator

 

[cdukes]

I dont think it is possible to restore just a table. The best way to get your table back is to restore the whole database onto another server (or your local PC) and copy the table back by using DTS.

Hope this helps,

Chris Dukes

 

[tlbroadbent]

You can also restore a database to the same sever with another name and then copy the table to the original database. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[foxdev]

I've always thought this was one key weakness of SQL Server, and I think that even more when I'm Lou's situation. While I'm sure there are sound technical/performance and integrity reasons why the Microsoft solution is the "preferred" method, it sure is a royal PITA when, say, someone runs an UPDATE command on a table without a WHERE clause. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[tlbroadbent]

I struggle to understand why table restore, a feature of SQL 6.5, is no longer a feature of SQL Server. Ah, progress! Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost