0
I am trying to make a copy of a database to the same server but am encountering error below:
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 tried to find this property "Maximumerrorcount" to try to change, but I couldn’t find it. I also don’t know if this is the way to solve the problem.
I am using sql server 2008
The message says that an error occurred while copying... Even if you increased the tolerance of the amount of errors, you would still not copy successfully. I think the best way to solve the problem is to find the exact error message in some log.
– Oralista de Sistemas
You’re right @Renan .. I went back and analyzed other lines of code and found an error in the table documents: The CREATE UNIQUE INDEX statement terminated because a Duplicate key was found for the Object name 'dbo.DOCUMENTS' and the index name 'Indexunicdocuments_documents_documentsnumero'
– Gleison França
Duplicate key. You have two options: 1) turn off index validation, copy, then turn on validation again or 2) exorcise duplicate key. In general people who make the second option are happier.
– Oralista de Sistemas
It worked Renan, Thanks for the help
– Gleison França