RESTORE detected an error on page (0:0) in database <database> as read from the backup set

18,759

It is possible that you have a bad bak file or the source database is corrupted.

Verifiy the source database:

DBCC CHECKDB('DatabaseName') WITH NO_INFOMSGS, ALL_ERRORMSGS on the server the backup was taken on.

Then try to backup it again and when copying the resulting bak, try to binary copy your file with other alternatives such as Robocopy, Copyfile, etc.

Share:
18,759
Scott
Author by

Scott

C# programmer

Updated on June 04, 2022

Comments

  • Scott
    Scott almost 2 years

    I'm attempting to restore a SQL Server 2012 .BAK file to my local server. I've successfully restored this .BAK file before. However now, when I try, I get the following error:

    RESTORE detected an error on page (0:0) in database 'databasename' as read from the backup set.

    Running the following command works:

    RESTORE HEADERONLY FROM DISK = 'D:\database.bak'
    

    However, running the following:

    RESTORE VERIFYONLY FROM DISK = 'D:\database.bak'
    

    Returns the following error:

    Msg 3203, Level 16, State 1, Line 1
    Read on "D:\database.bak" failed: 13(The data is invalid.)
    Msg 3013, Level 16, State 1, Line 1
    VERIFY DATABASE is terminating abnormally.
    

    I downloaded the .BAK file from an FTP server again this morning and got the same error. I asked someone else with access to the same backup file and they can restore it with no issues at all. Any ideas?