Restore SQL Server Database - Failed: 38 (Reach the end of the file.)

Question

I run the following script:

RESTORE DATABASE [Name_V2] FROM DISK = N'C:\20100920_Name_V2.bak' WITH MOVE N'Name_V2' TO N'C:\Program Files\...\Name_V2.mdf', MOVE N'Name_V2_log' TO N'C:\Program Files\...\Name_V2_log.ldf', REPLACE, STATS=1, FILE=1, NORECOVERY GO

When it starts, I get 70% processing, and I get the following error:

Msg 3203, Level 16, State 1, Line 1
Read on "C: \ 20100920_Name_V2.bak" failed: 38 (The end of the file has been reached.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE abnormally terminates.

I am not sure what the problem is. Can someone shed light on him? When I do RESTORE VERIFYONLY, I get an "end of file reached" error. When I do RESTORE FILELISTONLY from DISK, it returns with results listing .mdf and .ldf.

Thank you in advance!

Answer 1

Looks like a damaged or incomplete backup. See this msdn blog post at http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/b57ae7c2-9f86-48e1-a356-ceb105181bf8

Summary of related flow.

It seems that the backup file itself is damaged or the copy was incomplete.

Restore the end of the backup file until the database is fully restored.

Answer 2

This problem occurs because you are using an incomplete backup file.