Hi We have sql server 2008 standard edition. i have a requirement that the customers need to have a realtime data update onto the test machine from production. But if any issues reported in the production they want to able to run tests on the test machine, which would involve updating and processing the data in the test machine, and the changes done to the test do not propaget to the production. But is this possible with replication or mirroring on? this would throw the databases out of sync with replication and mirroring. If this is not possible how can we achieve this? Thanks,
You could probably use Log Shippung, Replication or Mirroring for this. My choice would possibly be Log Shipping. Either way you would have to stop the process once the issues are reported. At that point you would essentially have two separate databases. Take a backup of the test copy so you can easily go back to the point when the issues were noticed while you try running your tests. Once you have completed your tests you would need to reinitialise the replication/mirroring solution. This is why I would choose Log Shipping as it is likely to be easier to restart, depending on the backup/restore schedules that you use and how often the issues are likely to arise.