RE: Restore table in sql server

SSC Guru

Points: 323504

April 4, 2013 at 11:24 am

you restore the last good backup as a new database name.

then you can use cross database queries move differences from one table to another;

depending on the foreign keys, you might be prevented from just deleting the table and inserting again from the old, but the specifics would be unique to the tables and what data needs to be recovered(ie the table was deleted, vs transactions after 12 noon are missing, vs, bad data due to an update needs to be fixed, etc)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!