在SQL Server的本地环境中复制生产环境中的问题的好方法 [英] Good way to replicate issue in production environment in local environmnt in SQL server

问题描述

支持在生产环境中有大量数据（比如90GB），通过在生产服务器上打开活动监视器和分析器我们能够捕获跟踪/脚本。

运行此跟踪/脚本以在本地环境中复制问题的最佳方法是，不允许对生产数据进行数据库备份并在本地进行恢复。

如上所述，如果涉及大量数据，如何从本地生产环境中复制问题？

Hi,

Support there is a huge data (say 90GB)in production environment and by turning the activity monitor and profiler on in production server we are able to capture the trace/script.
What would be the best way to run this trace/script to replicate the issue in local environment as taking DB backup of production data and restoring locally is not allowed.
How to replicate the issue from production environment locally when there is a huge data involved as stated in the above stated scenario?

推荐答案

我不知道认为这将是一件容易的事。最好的选择是获取生产数据并加扰，以便不泄露敏感信息。只是其中一种可行的方法http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100066。

I don't think it will be easy task. The best alternative will be take a production data and scramble so that the sensitive information is not revealed. Just one of the possible ways of doing it http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100066.

这篇关于在SQL Server的本地环境中复制生产环境中的问题的好方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！