What's the Issue?
I've taken backup of SQL Server 2008 Database on server.
BACKUP DATABASE DBName TO DISK='D:\DBBackup\FileName.bak' with FORMAT
When I'm trying to restore that database, it gives me following error.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
ADDITIONAL INFORMATION:
The media family on device is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
What's the Solution?
1) Ensure Backup copy of database is good and files copied properly.
2) Run "Select @@Version" and verify the version. (Though I'm using SQL Server 2008 express, it is showing that i am using SQL Server 2005)
3) Run the SQL Server 2008 R2 Express install program again, and during Name Instance configuration, specify a Name Instance with a different name. Example: MachineName\instancename after installation, logged in with New Instance name created.
Create a new database with a table then try to restore again, It will work this time.
~
Jagadeesan Kandasamy
