Safeguard your rollback by storing the changes to data as they happen, not as a seperate step.
OUTPUT
Recently I’ve been making a lot of use of the OUTPUT option for insert and update actions. From this work I’ve already posted about the behaviour of IDENTITY and suchlike. Now I have looked at the behaviour of OUTPUT within the MERGE command.
Notes on SQL 