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

CSS
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
Posted

It looks like you have a sql 2005 server? And trying to restore a backup from a sql 2008 server? That will not work.
   
Comments
[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
   
v2
You are saving mdf and ldf file.

Use following query....

SQL
restore database SQL2008_561218_ots_backup from disk='D:\SQL2008_561218_ots_backup.bak'
WITH
MOVE 'DataTakeon_Data' TO 'D:\DataTakenon.mdf',
MOVE 'DataTakeon_Log'  TO 'D:\DataTakenon.ldf'
   
Comments
[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