Click here to Skip to main content
15,072,391 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all

I am executing the below query

restore database SQL2008_561218_ots_backup from disk='D:\SQL2008_561218_ots_backup.bak'

and i am getting below error

The media family on device 'D:\SQL2008_561218_ots_backup.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Please tell me where i am going wrong

It looks like you have a sql 2005 server? And trying to restore a backup from a sql 2008 server? That will not work.
[no name] 13-Aug-12 2:40am
any way to know the version of the backup file..????
StianSandberg 13-Aug-12 2:43am
See this thread on MSDN can one quickly determine sql version of a Database Backup file? by inspecting file header?

I just guessed because your backup file is named D:\SQL2008_561218_ots_backup.bak
You are saving mdf and ldf file.

Use following query....

restore database SQL2008_561218_ots_backup from disk='D:\SQL2008_561218_ots_backup.bak'
MOVE 'DataTakeon_Data' TO 'D:\DataTakenon.mdf',
MOVE 'DataTakeon_Log'  TO 'D:\DataTakenon.ldf'
[no name] 13-Aug-12 2:40am
sorry..its giving the same error..
Sant Osha 13-Aug-12 2:42am
so that means, you using different format of SQL..... don't restore...
export database
[no name] 13-Aug-12 2:54am
how to export..???

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900