Restore table from full dump

If you have a full dump of SQL backup, how can you recover a table?
You can buy a third part software, or restore a dump with a different name and copy the desidered table on original database.
Second step is drop the source table, (after backup) and write this:

select * into destination database.dbo.destination table
from source database.dbo.source table

You have replaced the source table with backup table. Good Work!

 

Leave a Reply