Error:

SQL Server detected a logical consistency-based I/O error: Incorrect checksum. It occurred during a read of page. This is a sever error condition that threatens database integrity and must be corrected immediately.

Error Message:

Causes:

There are multiple reasons for database suspect status.

1. Backup files corruption

2. Network break (if you are restoring from remote path)

3. Low disk space in destination.

Workarournd 1:

Execute the following Query to repair against the database

EXEC sp_resetstatus <Database-Name>

ALTER DATABASE <Database-Name> SET EMERGENCY

DBCC CHECKDB <Database-Name>

ALTER DATABASE <Database-Name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CHECKDB (<Database-Name>, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE <Database-Name> SET MULTI_USER

USE <Database-Name>

Workarournd 2:

Backup file may be corrupted. Not able to read the data. Try from different backup file.