Jeff you beat me to it. I would most certainly look at using Transactional Replication to solve this issue, assuming that's going to be suitable for your environment.

However the idea of capturing trace information is something I hadn't considered before and offers up some nice functionality such as repeatable tests which could be easily added into a dbfit FitNesse test for example.