none
Database copy wizard failed to copy database on targate server

    Question

  • I have got below error on copy database wizard. 

    Date 9/19/2013 2:00:00 PM
    Log Job History (CDW_TESTING_SQL2008_SYS13_SYS13_14)

    Step ID 1
    Server SYS13\SYS13
    Job Name CDW_-TESTING_SQL2008_SYS13_SYS13_14
    Step Name CDW_-TESTING_SQL2008_SYS13_SYS13_14_Step
    Duration 00:00:13
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    Executed as user: SYS13\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.4000.0 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:00:00  Progress: 2013-09-19 14:00:01.98     Source: TESTING_SQL2008_SYS13_SYS13_Transfer Objects Task      Task just started the execution.: 0% complete  End Progress  Error: 2013-09-19 14:00:11.32     Code: 0x00000000     Source: TESTING_SQL2008_SYS13_SYS13_Transfer Objects Task      Description: An exception occurred while executing a Transact-SQL statement or batch.  StackTrace:    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)     at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)     at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.CreateObject(String database, StringCollection script)     at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferJobs(DatabaseObject dbObject)  InnerException-->The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator).  StackTrace:    at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)     at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)  End Error  Progress: 2013-09-19 14:00:11.33     Source: -TESTING_SQL2008_SYS13_SYS13_Transfer Objects Task      Database transfer failed for one or more extra objects.: 0% complete  End Progress  Progress: 2013-09-19 14:00:11.33     Source: testingserver_SQL2008_SYS13_SYS13_Transfer Objects Task      Transfer objects finished execution.: 100% complete  End Progress  Warning: 2013-09-19 14:00:11.34     Code: 0x80019002     Source: CDW_TESTING_SQL2008_SYS13_SYS13_14      Description: 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.  End Warning  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:00:00  Finished: 14:00:11  Elapsed:  10.749 seconds.  The package execution failed.  The step failed.


    Akshay Pate Server Administrator

    Thursday, September 19, 2013 10:08 AM

Answers

  • Notice the inner exception:

    InnerException-->The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator)

    Execute sp_help_operator on your source server and add them to the target server using sp_add_operator.


    Brandon Williams (blog | linkedin)

    Thursday, September 19, 2013 4:41 PM
    Moderator

All replies

  • Notice the inner exception:

    InnerException-->The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator)

    Execute sp_help_operator on your source server and add them to the target server using sp_add_operator.


    Brandon Williams (blog | linkedin)

    Thursday, September 19, 2013 4:41 PM
    Moderator
  • OK Thanks for help will revert you asap


    Akshay Pate Server Administrator

    Sunday, September 22, 2013 7:22 AM