แก้ไข

แชร์ผ่าน


MSSQLSERVER_3183

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
Event ID 3183
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name LDDB_PAGE_ERROR_DURING_RESTORE
Message Text RESTORE detected an error on page (%d:%d) in database "%ls" as read from the backup set.

Explanation

This error is raised if a page validation fails when restoring a database backup that was performed with the CHECKSUM option. SQL Server terminates the restore operation and reports an error that looks like this:

Msg 3183, Level 16, State 1, Line 1
RESTORE detected an error on page (1:243) in database "corruption_errors_test" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

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

User Action