September 5, 2005 at 3:27 am
Hi ALL,
I am restoring from a backup file. Till last week sunday it was working fine. Today it is failing.
My database has gone in loading state.
I get this error :
Server : Msg 3241, Level 16, State 37, Line 1
The media famly on device is incorrectly formed.SQL server cannot process this media family.
I tried restore verifyonly, but still getting the same error.
Please advice how can I restore my database.
--Kishore
September 8, 2005 at 8:00 am
This was removed by the editor as SPAM
September 8, 2005 at 11:20 am
I would drop the media set name re-create another backup job, and try to restore from the new backup
September 8, 2005 at 12:14 pm
How was the backup done?
Did you backup to disk first and then copy the backup to tape? If so, you need to reverse the order, you won't be able to restore directly from the tape.
Did you copy the .mdf and .ldf files to tape? If so, you can't restore them. You need to attach them. However, you can't do this if you didn't originally detach the database.
-SQLBill
September 8, 2005 at 12:15 pm
What kind of backup is this? Is it a FULL backup?
-SQLBill
November 1, 2005 at 12:29 am
When you perform a backup or restore operation and the transaction log is greater than four gigabytes (or 2^32 bytes), the LogMgr::ValidateBackedupBlock method may cause the following error when it computes the offset of the log block in the physical file:
pls see ...
November 1, 2005 at 12:31 am
When you perform a backup or restore operation and the transaction log is greater than four gigabytes (or 2^32 bytes), the LogMgr::ValidateBackedupBlock method may cause the following error when it computes the offset of the log block in the physical file:
pls see ...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply