"Faraz Khan" <faraz.khan@ezdoc.net> wrote in message
news:a75fab3a.0409242240.379ff9fb@posting.google.com...
> Here is the scenario. My company uses a table to construct what-if
> scenarios. After playing around with different values in the table,
> they may want to keep the final table or start over with the table
> from the point they start the sessions. These sessions can last for
> days or weeks.
>
> Is there a generic way of saving the table at one point in time and
> later restoring it to that exact state? Like a transaction roll back.
> But this transaction has to continue for several weeks during which a
> connection cannot be maintained and several users may alter the data
> in the table (insert, update & delete). Other tables in the DB may be
> all changing during this time. We must not roll back them.
>
> By generic i mean easy, and quick. I have been doing this by making a
> backup of the database and then later restore it to a new db and copy
> just the table i need. Is there a better way? An automatic or
> semi-automatic way?