>>>Thank you for the explanation. Ideally I would like to "restore" the table with all indexes, triggers, etc. The way I understand it, is that I would then (after doing a test run) truncate the "good" table and Select from the "backup" table into this "good" table. Can I assume that when I truncate the table, the triggers and indexes will not be affected and therefore Selecting into will Restore?
>>>
>>There are some rules in regards to which table can be truncated and which can not. Assuming that this table can be truncated, then yes, everything will be in place. Watch out for Identity fields, though - you may need to explicitly re-set it when you will be restoring the table.
>
>I am not concerned about identity fields (there is no relation for them to other tables). I just want to be sure that when I do each test run it is executed agains the same set of records.
>Thank you.

SET IDENTITY_INSERT (Transact-SQL)
http://technet.microsoft.com/en-us/library/ms188059.aspx

MartinaJ