April 23, 2012 at 12:46 am
//when i adding my restore database file i am getting this error..
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device 'D:\MultiCloud\Database\MultiCloud.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
April 23, 2012 at 1:18 am
Where do you get the backup from??...Directly from the database or you download/FTP the backup file from somewhere?....Have you tried restoring it as a fresh database?
I think it might be an issue of a corrupted backup file.
April 23, 2012 at 4:03 am
When I've seen this before, it's when someone is attempting to restore a higher version of a SQL Server backup to a lower version of SQL Server (i.e. a SQL Server 2008 R2 backup to SQL Server 2005).
Hope this helps.
April 23, 2012 at 7:41 am
Why don't we start with the basics...
1. How is the backup created; i.e. Script please...
2. How are you restoring; again, script please.
Jared
CE - Microsoft
April 24, 2012 at 2:31 am
I agree you may find that you are trying to restore from SQL 2008 R2 to SQL 2008. Very frustrating
April 24, 2012 at 7:13 am
You may check if the backup is restorable or not with RESTORE VERIFYONLY. You might also be having a corrupt backup file.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
April 24, 2012 at 7:34 am
Why don't we all try waiting for the answers to the basic questions before firing off "supposed" solutions. It will keep this thread cleaner and get down to the real solution much more efficiently.
Jared
CE - Microsoft
April 24, 2012 at 10:36 pm
April 25, 2012 at 7:09 am
vinu512 (4/24/2012)
MAAAAN!!!!...He really knows it all....lol 😀+1 SQLKnowItAll....I agree.
Hehehehe... I certainly don't! Of course, that's what makes it a clever name for my blog. Anyone want to buy it? 🙂
Jared
CE - Microsoft
April 26, 2012 at 12:34 am
SQLKnowItAll (4/25/2012)
vinu512 (4/24/2012)
MAAAAN!!!!...He really knows it all....lol 😀+1 SQLKnowItAll....I agree.
Hehehehe... I certainly don't! Of course, that's what makes it a clever name for my blog. Anyone want to buy it? 🙂
You're not at all bad at Marketing either...lol
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply