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
Post a Comment