SQL table data restore - TechRepublic
Question
July 17, 2009 at 01:21 AM
gordinho

SQL table data restore

by gordinho . Updated 16 years, 12 months ago

Hi,

I need to restore specific lines of an SQL 2000 db table from backup to live db. I can’t use DTS import as this will only append lines in the live db table ? The table is not corrupt but a user has deleted some data in the table that I need to reconstruct from backup ideally without having to type the lines in manually (not that there are many of them). Anyone know of any simple table compare and insert into type scripting engine? I’m not really a SQL dba so if any SQL gurus can help I’d appreciate any pointers.

cheers

G

This discussion is locked

All Comments