Replace SQL DB Table

Replace SQL DB Table

  
Hi all,
I want to replace one SQL DB table from a backup.
I'd deleted some records, but i want to preserve the Identity Keys.
If I try to insert this data with the Insert Into I will get new Indentities.
Is there anyone who can help to solve this issue?
Thanks
Hi João,

You can use SET IDENTITY_INSERT temporarily to allow using the Id column in the insert.

Regards,
João Rosado