This article is half-done without your Comment! *** Please share your thoughts via Comment ***
SQL Server Error:
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (8888:65987423) in database “my_db” as read from the backup set
While restoring a SQL Server database from the backup file (.bak file), I got above error. It looks like a database backup corrupted for particular data page.
Following are different reasons behind the error 3183:
- The backup file got corrupted
- Unavailability of free space on temporary disk
- Maybe backup file harm by the viruses
- Trying to restore a backup on a server with lower version than the backup created
- Failure of any hardware or bad sector of hard drive
The possible solutions are:
- You should try RESTORE VERIFYONLY to see more information about the backup failure
- Verify the source database, use DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS on the server the backup was taken on and try to backup it again
- You could try using RECOVER DATABASE WITH CONTINUE_AFTER_ERROR with the backup command, then run a DBCC CHECKDB on the database
