Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    10

    Question Unanswered: Copy Database Wizard Error SQL Server 2008 R2

    I am trying to copy database from one server to another using the
    Copy Database Wizard in SQL Server 2008 R2. The process fails in the last step.
    The error msg is not clear and it says there are more than two errors etc etc. Can anyone help me in this matter

  2. #2
    Join Date
    Oct 2011
    Posts
    29
    Have you got any error number in message ? Please post full error message .
    for copying database you can also try with backup and restore.

  3. #3
    Join Date
    May 2011
    Posts
    10

    Error Message

    This is the error message that I am getting

    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.

    I want to schedule the backup process that is why I am using Copy Database Wizard.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •