4,707 questions
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?
sql backup error how to resolve it
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 76%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
chen focus
1
Reputation point
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.
Developer technologies Transact-SQL
SQL Server Other
14,494 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2022-01-27T05:31:55.09+00:00 Hi chenfocus-1817,
Welcome to Microsoft Q&A.
Are you using maintenance plan to backup database? Or using SSIS package?
If you are using maintenance plan, please go to management -> right-click the Maintenance Plan -> View history to check if there are any detailed error massage.
You can also try to run the query in the SSMS directly to see if it can execute successfully or there are any error message.Best Regards,
Amelia -
Olaf Helper 47,436 Reputation points2022-01-28T06:08:11.807+00:00 Are you using maintenance plan to backup database? Or using SSIS package?
A maintance plan is a SSIS package in background.
-
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
2022-02-07T07:04:59.347+00:00 Hi chenfocus-1817,
How are things going? Is your issue resolved?
If not, please don't hesitate to let us know and share us more information in order to provide further help.Best Regards,
Amelia
Sign in to comment
1 answer
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points
2022-01-26T12:38:32.383+00:00