September 4, 2011 at 1:23 pm
I have DB Backup file that couldn't restore as it showing me error msg that is
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'TEST_DB' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I tried Restore FilesListonly which give me two files like this
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TEJ_DATA.mdf
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TEJ_DATA.ldf
Restore VerifyOnly
Msg 3242, Level 16, State 2, Line 1
The file on device 'D:\New Folder\TEJ06082011.BAK' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
It was corrupted when i Zip the BAKUP File ,While extracting the Backup it says that 'CRC Corrupted' and it partially Repaired using WINRAR Repair Tool.
Is there any way to restore the Backup without lose data?
Please help me
thanks in advance,
September 4, 2011 at 2:28 pm
The first error is just telling you that you're about to restore a different database over one you have. Use RESTORE ... WITH REPLACE to remove that warning. However, if the backup really is corrupt (as the VerifyOnly error implies) then you won't be able to restore it at all. Get a new backup that hasn't been damaged in transmission.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply