尝试从服务器到另一台服务器执行数据库复制 [英] Trying to perform a database copy from server to another server
问题描述
有没有人使用SMSS"复制数据库"成功地将数据库副本从一个服务器复制到另一个服务器。 ？功能 我无法让它正常工作。
Has anyone ever successfully performed a database copy from one server to another using the the SMSS "Copy Database" feature? I am unable to get it to work properly.
#Fields：事件，计算机，运算符，源，sourceid，executionid，starttime，endtime，datacode，databytes，message
OnPreValidate，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C} ，4/19/2019 1:04:48 PM，4/19/2019：04：48 PM，0,0x，
OnPreValidate，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D-48FA-9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：04：48 PM，4/19 / 2019 1:04:48 PM，0,0x，
OnPostValidate，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D- 48FA-9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019：04：48 PM，0,0x，
OnPostValidate，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C 5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019：04：48 PM，0,0x，
PackageStart，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19 / 2019 1:04:48 PM，4/19/2019 1:04:48 PM，0,0x，包裹开始执行。
DiagnosticEx，ISCH- SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019 1:04 ：48 PM，4/19/2019：04：48 PM，0,0x，<？xml version =" 1.0"？>< DTS：PipelineColumnMap
xmlns：DTS =" www .microsoft.com / SqlServer / Dts" />
Diagnostic，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18 -D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019 1:04:48 PM，0,0x，最大并发可执行文件设置为1.
DiagnosticEx，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82 -FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019：04：48 PM，0,0x，<？xml version =" 1.0"？>< DTS： ParameterValues
xmlns：DTS =" www.microsoft.com/SqlServer/Dts" />
OnPreExecute，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH- SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019 1:04:48 PM，0,0x，
OnPreExecute，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D-48FA-9C6E-BE2A421CEF3C}， {3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019：04：48 PM，0,0x，
OnPreValidate， ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D-48FA-9C6E-BE2A421CEF3C}，{3AA5CE 37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019：04：48 PM，0,0x，
OnPostValidate，ISCH -SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D-48FA-9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019 1：04：48 PM，4/19/2019：04：48 PM，0,0x，
OnProgress，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql -20_res_Transfer Objects Task，{26433B9D-578D-48FA-9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019 1:04： 48 PM，0,0x，Task刚开始执行。
OnInformation，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D- 48FA-9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019：04：04：48 PM，0,0x，连接到服务器SQLSRV1 \TRAVERSE11
OnInformation，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RE S，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：48 PM，4/19/2019：04：48 PM， 0,0x，连接到服务器SQLSRV1 \TRAVERSE11
OnError，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D-48FA- 9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：04 PM，4/19/2019 1:04:49 PM，0,0x，无法连接到服务器SQLSRV1 \TRAVERSE11。
$
StackTrace： 在Microsoft.SqlServer.Management.Common.ConnectionManager.Connect（）
在Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection（服务器和服务器，ServerProperty serverProp）
InnerException - >用户'ISS\ISCH-SQL-20 $'登录失败。$
StackTrace： at System.Data.SqlClient.SqlInternalConnectionTds..ctor（DbConnectionPoolIdentity identity，SqlConnectionString connectionOptions，SqlCredential credential，Object providerInfo，String newPassword，SecureString newSecurePassword，
Boolean redirectedUserInstance，SqlConnectionString userConnectionOptions，SessionData reconnectSessionData，DbConnectionPool pool，String accessToken，Boolean applyTransientFaultHandling，SqlAuthenticationProviderManager sqlAuthProviderManager）
在System.Data.SqlClient.SqlConnectionFactory.CreateConnection（DbConnectionOptions选项，DbConnectionPoolKey poolKey，对象poolGroupProviderInfo，DbConnectionPool池，DbConnection owningConnection，DbConnectionOptions userOptions）
在System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection（DbConnectionPool池，DbConnection owningObject，DbConnectionOptions选项，DbConnectionPoolKey poolKey，DbConnectionOptions userOptions）
在System.Data.ProviderBase.DbConnectionPool.CreateObject（DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection）
在System.Data.ProviderBase.DbConnectionPool.UserCreateRequest（DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection）
在System.Data.ProviderBase.DbConnectionPool.TryGetConnection（DbConnection owningObject，UInt32 waitForMultipleObjectsTimeout，Boolean allowCreate，Boolean onlyOneCheckConnection，DbConnectionOptions userOptions，DbConnectionInternal& connection）
在System.Data.ProviderBase.DbConnectionPool.TryGetConnection（DbConnection owningObject，TaskCompletionSource`1 retry，DbConnectionOptions userOptions，DbConnectionInternal& connection）
在System.Data.ProviderBase.DbConnectionFactory.TryGetConnection（DbConnection owningConnection，TaskCompletionSource`1 retry，DbConnectionOptions userOptions，DbConnectionInternal oldConnection，DbConnectionInternal& connection）
在System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal（DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource`1 retry，DbConnectionOptions userOptions）
在System.Data.SqlClient.SqlConnection.TryOpenInner（TaskCompletionSource`1重试）
在System.Data.SqlClient.SqlConnection.TryOpen（TaskCompletionSource`1重试）
在System.Data.SqlClient.SqlConnection.Open（）
在Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect（WindowsIdentity impersonatedIdentity）
在Microsoft.SqlServer.Management.Common.ConnectionManager.Connect（）
OnError，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871 -AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：49 PM，4/19/2019：04：04 PM，0,0x，无法连接到server SQLSRV1 \TRAVERSE11。
$
StackTrace： 在Microsoft.SqlServer.Management.Common.ConnectionManager.Connect（）
在Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection（服务器和服务器，ServerProperty serverProp）
InnerException - >用户'ISS\ISCH-SQL-20 $'登录失败。$
StackTrace： at System.Data.SqlClient.SqlInternalConnectionTds..ctor（DbConnectionPoolIdentity identity，SqlConnectionString connectionOptions，SqlCredential credential，Object providerInfo，String newPassword，SecureString newSecurePassword，
Boolean redirectedUserInstance，SqlConnectionString userConnectionOptions，SessionData reconnectSessionData，DbConnectionPool pool，String accessToken，Boolean applyTransientFaultHandling，SqlAuthenticationProviderManager sqlAuthProviderManager）
在System.Data.SqlClient.SqlConnectionFactory.CreateConnection（DbConnectionOptions选项，DbConnectionPoolKey poolKey，对象poolGroupProviderInfo，DbConnectionPool池，DbConnection owningConnection，DbConnectionOptions userOptions）
在System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection（DbConnectionPool池，DbConnection owningObject，DbConnectionOptions选项，DbConnectionPoolKey poolKey，DbConnectionOptions userOptions）
在System.Data.ProviderBase.DbConnectionPool.CreateObject（DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection）
在System.Data.ProviderBase.DbConnectionPool.UserCreateRequest（DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection）
在System.Data.ProviderBase.DbConnectionPool.TryGetConnection（DbConnection owningObject，UInt32 waitForMultipleObjectsTimeout，Boolean allowCreate，Boolean onlyOneCheckConnection，DbConnectionOptions userOptions，DbConnectionInternal& connection）
在System.Data.ProviderBase.DbConnectionPool.TryGetConnection（DbConnection owningObject，TaskCompletionSource`1 retry，DbConnectionOptions userOptions，DbConnectionInternal& connection）
在System.Data.ProviderBase.DbConnectionFactory.TryGetConnection（DbConnection owningConnection，TaskCompletionSource`1 retry，DbConnectionOptions userOptions，DbConnectionInternal oldConnection，DbConnectionInternal& connection）
在System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal（DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource`1 retry，DbConnectionOptions userOptions）
在System.Data.SqlClient.SqlConnection.TryOpenInner（TaskCompletionSource`1重试）
在System.Data.SqlClient.SqlConnection.TryOpen（TaskCompletionSource`1重试）
在System.Data.SqlClient.SqlConnection.Open（）
在Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect（WindowsIdentity impersonatedIdentity）
在Microsoft.SqlServer.Management.Common.ConnectionManager.Connect（）
OnProgress，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D -48FA-9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：49 PM，4/19/2019：04：04 PM，100,0x，转移物体完成
执行。
OnTaskFailed，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D-48FA-9C6E-BE2A421CEF3C} ，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：49 PM，4/19/2019：04：49 PM，0,0x，
OnPostExecute ，ISCH-SQL-20，NT Service\SQLAgent $ RES，SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task，{26433B9D-578D-48FA-9C6E-BE2A421CEF3C}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19 / 2019 1:04:49 PM，4/19/2019：04：49 PM，0,0x，
OnWarning，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH -SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE3 7-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：49 PM，4/19/2019：04：49 PM，-2147381246,0x，SSIS警告代码DTS_W_MAXIMUMERRORCOUNTREACHED。
执行方法成功，但引发的错误数（1）达到允许的最大值（1）;导致失败。当错误数达到MaximumErrorCount中指定的数量时，会发生这种情况。更改MaximumErrorCount或修复错误。
OnPostExecute，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501 -4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019：04：04 PM，4/19/2019：04：49 PM，0,0x，
DiagnosticEx，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C }，4/19/2019：04：49 PM，4/19/2019：04：49 PM，0,0x，<？xml version =" 1.0"？>< DTS：ProcessMemoryUsage
xmlns：DTS =" www.microsoft.com/SqlServer/Dts">< DTS：PeakWorkingSetSize> 49745920< / DTS：PeakWorkingSetSize>< / DTS：ProcessMemoryUsage>
PackageEnd ，ISCH-SQL-20，NT Service\SQLAgent $ RES，CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES，{89749DEB-9501-4871-AA18-D881040C5637}，{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C}，4/19/2019下午1:04:49，4/19/2019 1:04:49，1,0x，包裹执行结束。
#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
OnPreValidate,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
OnPostValidate,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
OnPostValidate,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
PackageStart,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,Beginning of package execution.
DiagnosticEx,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,<?xml version="1.0"?><DTS:PipelineColumnMap
xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>
Diagnostic,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,Maximum concurrent executables are set to 1.
DiagnosticEx,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,<?xml version="1.0"?><DTS:ParameterValues
xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>
OnPreExecute,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
OnPreExecute,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
OnPreValidate,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
OnPostValidate,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,
OnProgress,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,Task just started the execution.
OnInformation,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,Connecting to server SQLSRV1\TRAVERSE11
OnInformation,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:48 PM,4/19/2019 1:04:48 PM,0,0x,Connecting to server SQLSRV1\TRAVERSE11
OnError,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,0,0x,Failed to connect to server SQLSRV1\TRAVERSE11.
StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)
InnerException-->Login failed for user 'ISS\ISCH-SQL-20$'.
StackTrace: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword,
Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)
at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
OnError,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,0,0x,Failed to connect to server SQLSRV1\TRAVERSE11.
StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)
InnerException-->Login failed for user 'ISS\ISCH-SQL-20$'.
StackTrace: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword,
Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)
at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
OnProgress,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,100,0x,Transfer objects finished
execution.
OnTaskFailed,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,0,0x,
OnPostExecute,ISCH-SQL-20,NT Service\SQLAgent$RES,SQLSRV1_TRAVERSE11_isch-sql-20_res_Transfer Objects Task,{26433B9D-578D-48FA-9C6E-BE2A421CEF3C},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,0,0x,
OnWarning,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,-2147381246,0x,SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.
The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
OnPostExecute,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,0,0x,
DiagnosticEx,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,0,0x,<?xml version="1.0"?><DTS:ProcessMemoryUsage
xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:PeakWorkingSetSize>49745920</DTS:PeakWorkingSetSize></DTS:ProcessMemoryUsage>
PackageEnd,ISCH-SQL-20,NT Service\SQLAgent$RES,CDW_SQLSRV1_TRAVERSE11_ISCH-SQL-20_RES,{89749DEB-9501-4871-AA18-D881040C5637},{3AA5CE37-620F-4F18-AF82-FF1ECDDD162C},4/19/2019 1:04:49 PM,4/19/2019 1:04:49 PM,1,0x,End of package execution.
推荐答案
每当我将数据库从一个服务器移动到另一个服务器，我在源服务器上对数据库进行完整备份，将备份文件复制到目标服务器，然后在那里恢复备份。您可能更幸运的是使用这种数据库迁移方法，
而不是尝试进行数据库复制。
Whenever I move a database from one server to another, I take a full backup of the database on source server, copy the backup file to destination server and then restore the backup there. You might have better luck with that method of database migration, rather than trying to do a database copy.
HTH，
这篇关于尝试从服务器到另一台服务器执行数据库复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
