3043

Product Name

Event ID

3043

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

DMP_PAGE_ERROR_DURING_BACKUP

Message Text

BACKUP ‘%ls’ detected an error on page (%d:%d) in file ‘%ls’.

This error is raised during a backup operation if SQL Server detects that a page is damaged.

Specifically you get this error if the page checksum validation fails during the backup

operation. The validation failure is a result of a corrupt database page. A record of the detected

bad page would be added to the suspect_pages table in MSDB.

A database page could be damaged due to many reasons including hardware failures and OS

issues.

In this scenario, SQL Server stops the backup operations and reports an error like this:

Output

When you use the CHECKSUM option during a backup operation, the following processes are

enabled:

ﾉ

Expand table

Msg 3043, Level 16, State 1, Line 1
BACKUP 'database_name' detected an error on page (file_id:page_number) in file
'database_file'.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.