当我们将数据从本地服务器导出到sql server中的远程服务器时？ [英] When we export data from local server to remote server in sql server?

问题描述

当我们在sql server 2008中将数据从本地服务器导出到远程服务器时。然后是否创建了任何日志？



有没有办法跟踪从本地服务器导出数据？

解决方案

通过SSMS使用时，导入-Export向导工具没有日志记录功能，除非保存为包;我们可以利用SSIS提供的日志记录功能。此外，无论何时从数据库对象添加或删除数据，SQL Server的内部日志记录功能都会动作。因此，如果我们担心在执行wizrd期间可能发生的任何异常，则会发生回滚。

When we export data from local server to remote server in sql server 2008 . Then is there any log created ?

Is there any possible way to trace That data is being exported from local server ?

解决方案

The Import -Export wizard tool when used through SSMS does not have a logging feature,until and unless, saved as a package; where we can take advantage of the logging feature provided with the SSIS. Additionally, whenever data is added or deleted from a database object, the internal logging feature of SQL server kicks into action.So,if we are concerned about any anomalies that might occur during the execution of the wizrd, then rollback does occurs.

这篇关于当我们将数据从本地服务器导出到sql server中的远程服务器时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！