SQL Server 2008R2 – Database Restore – failed 38 (reached the end of the file)

Varinder Sandhu SQL, SQL-Backup & Restore, SQL-Tips and Tricks, Varinder Sandhu

While restoring the SQL database error occurred…

Through UI following error occurred

Database Restore – failed 38 (reached the end of the file)

Through Script following error occurred

Script:

RESTORE DATABASE mydb
FROM DISK = 'D:\ DB Backup\mydb.bak'
WITH MOVE 'mydb_Data' TO 'E:\Database\mydb.mdf',
MOVE 'mydb_Log' TO 'E:\Database\mydb.ldf',
REPLACE
GO

Msg 3203, Level 16, State 1, Line 1
Read on “D:\ DB Backup\mydb.bak” failed: 38(Reached the end of the file.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

I have taken the other backup file then it works fine. So it appears that the backup file itself is corrupt, or the copy was incomplete.

One can also refer :
http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/b57ae7c2-9f86-48e1-a356-ceb105181bf8