Share via

Backup SQL Failed

Hai, Do Duc 20 Reputation points
2025-01-14T07:24:30.89+00:00

Hello Everyone!

When i backup SQL, i saw this issue, please help me to fix it

Message

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 1:20:00 AM Progress: 2025-01-14 01:20:00.43 Source: {BF631D24-7C67-4B70-B16C-10552C9A98A4} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2025-01-14 01:20:20.57 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [585] TO DISK = N'E:\Globe backup..." failed with the following error: "BACKUP '585' detected an error on page (1:2647944) in file 'E:\Globe database\585.mdf'. BACKUP DATABASE is terminating abnormally. 10 percent processed. 20 percent processed. 30 percent processed. 40 percent processed. 50 percent processed. 60 percent processed. 70 percent processed. 80 percent processed. 90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Warning: 2025-01-14 01:20:20.57 Code: 0x80019002 Source: 585 Backup daily 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: 1:20:00 AM Finished: 1:20:20 AM Elapsed: 20.406 seconds. The package execution failed. The step failed.

Thank You!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,400 questions
Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
482 questions
0 comments
Accepted answer
  1. Olaf Helper 45,776 Reputation points
    2025-01-14T07:29:23.48+00:00

    BACKUP '585' detected an error on page (1:2647944) in file 'E:\Globe database\585.mdf'.

    Seems your database file is corrupt.

    Check the database with CHECKDB command, see

    https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver16

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.