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