sql backup error how to resolve it

chen focus 1 Reputation point
2022-01-26T12:06:15.917+00:00

Executing query "BACKUP LOG [zktime_LindeEx] TO DISK = N'E:\Backup...".: 100% complete End Progress Warning: 2022-01-26 19:50:01.98 Code: 0x80019002 Source: Subplan_1 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: 7:49:58 PM Finished: 7:50:02 PM Elapsed: 3.906 seconds. The package execution failed. The step failed.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 41,006 Reputation points
    2022-01-26T12:38:32.383+00:00

    Please View the SQL Server error log in SQL Server Management Studio (SSMS) if you can find some more details about the error.
    Is there enough free space on the storage for the backup?

    0 comments No comments