none
Trying to perform a database copy from server to another server

    Question

  • 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: 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.

    Tuesday, April 23, 2019 7:46 PM

All replies

  • 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,


    Phil Streiff, MCDBA, MCITP, MCSA

    • Edited by philfactor Tuesday, April 23, 2019 7:50 PM
    Tuesday, April 23, 2019 7:49 PM

  • 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$'.

    Hi eharvilicz,

    Please check if the instance name SQLSRV1\TRAVERSE11 is correct and if this server SQLSRV1\TRAVERSE11 is configured to allow remote connections. 

    Please refer to the following links.

    Use the Copy Database Wizard

    SQL Server Remote Connection 

    Best Regards,

    Mona Lv


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com



    Wednesday, April 24, 2019 7:41 AM