Restore SQL Server Database - failed: 38(Reached the end of the file.) -


i running following script:

restore database [name_v2] disk = n'c:\20100920_name_v2.bak' move n'name_v2' n'c:\program files\...\name_v2.mdf', move n'name_v2_log' n'c:\program files\...\name_v2_log.ldf', replace, stats=1, file=1, norecovery go

when runs, 70 percent processed, , following error:

msg 3203, level 16, state 1, line 1
read on "c:\20100920_name_v2.bak" failed: 38(reached end of file.)
msg 3013, level 16, state 1, line 1
restore database terminating abnormally.

i'm not sure problem is. can shed light on it? when restore verifyonly on it, same 'reached end of file' error. when restore filelistonly disk, comes results listing .mdf , .ldf.

thank in advance!

looks corrupted or incomplete backup. see post on msdn blogs http://social.msdn.microsoft.com/forums/en/sqldisasterrecovery/thread/b57ae7c2-9f86-48e1-a356-ceb105181bf8

summary of thread linked..

it appears backup file corrupt, or copy incomplete.

restore reached end of backup file before database restored.


Comments