March 2, 2013 at 3:28 am
Trying to restore an SQL 2008 R2 backup, to SQL 2008 R2 - different machine:
RESTORE DATABASE [mydb]
FROM DISK = N'd:\test\test.bak'
WITH FILE = 1, MOVE N'modeldev'
TO N'd:\test\test.mdf',
MOVE N'modellog' TO N'd:\test\test.ldf',
NOUNLOAD, REPLACE, STATS = 10
Output & Error
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
Msg 3203, Level 16, State 1, Line 2
Read on "d:\test\test.bak" failed: 38(failed to retrieve text for this error. Reason: 15105)
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
C# Gnu
____________________________________________________
March 2, 2013 at 4:08 am
Do you have enough space for this db? If yes try this, maybe the backup is damaged.
RESTORE VERIFYONLY FROM DISK= N'd:\test\test.bak'
March 2, 2013 at 4:16 am
Hi, yes there is enough space.
I tried your verify command - and I get the same error ->
Msg 3203, Level 16, State 1, Line 1
Read on "d:\test\test.bak" failed: 38(failed to retrieve text for this error. Reason: 15105)
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
C# Gnu
____________________________________________________
March 2, 2013 at 5:09 am
Restore from another backup file.
March 2, 2013 at 9:05 am
The Error reported is commonly seen when the database backup file is corrupt.
As others have suggest, you should obtain a new database backup of the source database.
March 2, 2013 at 9:12 am
Not so easy for me to obtain another bak file - is there a free repair tool anywhere?
C# Gnu
____________________________________________________
August 27, 2014 at 6:05 am
I think in such cases the help of external software is beneficial as well as time efficient.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply