September 8, 2012 at 3:53 am
I've DB back up from SQL Express Edition, I need to restore this DB backup into SQL Server 2005\2008.
I got below said error when restoring into SQL Server 2005.
An exception occured while executing a Transact-SQL statement or batch
(Microsoft.SqlServer.ConnectionInfo)
Additional information:
The media family on device "E:\DBInv.bak" is incorrectly formed. SQL Server cannot process this medi
family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error:3241)
Can you please help me on this?
Thx.
September 8, 2012 at 4:35 am
That looks like a corrupt backup.
Take a new backup and try again. What version is the SQL Express instance?
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
September 8, 2012 at 9:46 am
That looks like you are trying to restore a backup created on 2008 to a 2005 instance. That cannot be done - you can go from 2005 to 2008, but not 2008 back to 2005.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply