SQL Server 2008 - Error on Restore Database

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

tkjagadheesh@hotmail.com