开发者

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

开发者 https://www.devze.com 2023-02-25 14:43 出处:网络
I am running the following script: RESTORE DATABASE [Name_V2] FROMDISK = N\'C:\\20100920_Name_V2.bak\' WITH

I am running 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 runs, I get to 70 percent processed, and I get the following error:

Msg 3203, Level 16, State 1, Line 1

Read on "C:\20100920_Name_V2.bak" failed:开发者_如何学C 38(Reached the end of the file.)

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

I'm not sure what the problem is. Can someone shed some light on it? When I do a RESTORE VERIFYONLY on it, I get the same 'reached end of the file' error. When I do a RESTORE FILELISTONLY FROM DISK, it comes back with the results listing the .mdf and .ldf.

Thank you in advance!


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

Summary of thread linked..

It appears that the backup file itself is corrupt, or the copy was incomplete.

Restore reached the end of the backup file before the database was fully restored.


This issue is happening because you are using an incomplete backup file.

0

精彩评论

暂无评论...
验证码 换一张
取 消