N/APosted on - 08/21/2011
Need Help with Microsoft SQL Server Studio. Please tell me the solution to this error, how can I remove this error.
Detail of Error:
Microsoft SQL Server Management Studio
An exception occurred while executing a Transact-SQL statement or batch.
The media family on device ‘C:Program FilesMicrosoft SQL ServerMSSQLBACKUPMasterct.bak’ is incorrectly formed. SQL Server cannot process this media family.
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3241)
Microsoft SQL Server Management Studio Error
So you are restoring a database from a backup file.
Here are a few suggestions that could help you:
Make sure the backup file is not corrupted. To check if it is not corrupted, you may run this Transact-SQL statement: “RESTORE VERIFYONLY”. This would check if the backup is complete and entirely readable.
I'm just guessing you are using multiple SQL server versions, when you backup database and restore. If this is the scenario, you backup your database from the development server using SQL Server 2008 or 2005, and restore the database to the production server with SQL server lower version, then you will really get that error message.
That is because lower version cannot recognize backups from higher version. If this is the case, you can use SQL Server Database Publishing Wizard. It can deploy SQL server database to your production server on lower versions like SQL Server 2000 or SQL Server 2005.