Restore SQL DB via SQL Agent gives Error E8562

[Jimbotech13]

Trying to restore a large MS SQL 2000 DB (69GB total) to a different SQL server (not the one the backup came from) but keep getting error E8562 after approx. 49GB of data has been restored.

Not sure of what to try, have no problems restoring other smaller DBs to this server.

In dbasql.log the final lines are as follows:

2/11/2005 11:48:41.967 sql_load_db(): SQLExecDirect failed for DB = [HDSGBI]. Error = -1

2/11/2005 11:48:42.14 [SQL Server] szSqlState = S1000,fNativeError = 823, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x00000000012000 in file 'D:\MSSQL\MSSQL\RESTORE\Data\HDS_Reports.mdf'.

2/11/2005 11:48:42.61 sql_load_db(): SQLExecDirect failed for DB = [HDSGBI]. Error = [SQL Server] szSqlState = S1000,fNativeError = 823, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x00000000012000 in file 'D:\MSSQL\MSSQL\RESTORE\Data\HDS_Reports.mdf'.

2/11/2005 11:48:42.108 [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x00000000012000 in file 'D:\MSSQL\MSSQL\RESTORE\Data\HDS_Reports.mdf'.
2/11/2005 11:48:42.155 sql_load_db(): sqlexec is DONE for DB = [HDSGBI]

Looks like a bad backup? Could that be the case?
Appreciate any help!

 

[Jimbotech13]

Anybody seen this issue before? Really need some help!

 

[vschumpy]

Could be a bad backup - you could try running the SQL errors through Microsoft's site too - they are errors from the SQL backup interface.