>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
