need help in sql query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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 12-Aug-12 20:33pm

Code-Hunt

Add a Solution

4 solutions

Add a Solution

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

StianSandberg · Answer 1 · 2012-08-12T20:37:00

Solution 1

It looks like you have a sql 2005 server? And trying to restore a backup from a sql 2008 server? That will not work.

Posted 12-Aug-12 20:37pm

StianSandberg

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

Santhosh Kumar Jayaraman · Answer 2 · 2012-08-12T20:37:00

Solution 2

Check this.

http://dotnetguts.blogspot.in/2010/06/restore-failed-for-server-restore.html[^]

http://sqlserverlearner.com/2011/the-media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-media-family-error-3241[^]

Posted 12-Aug-12 20:37pm

Santhosh Kumar Jayaraman

Aarti Meswania · Answer 3 · 2012-08-12T20:53:00

Solution 4

may be your backup file is corrupted.
check this links

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/4d5836f6-be65-47a1-ad5d-c81caaf1044f/[^]

http://www.sqlcoffee.com/Troubleshooting047.htm[^]

Happy Coding!
:)

Posted 12-Aug-12 20:53pm

Aarti Meswania

Updated 12-Aug-12 20:54pm

v2

Sant Osha · Answer 4 · 2012-08-12T20:39:00

Solution 3

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'

Posted 12-Aug-12 20:39pm

Sant Osha

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..???

need help in sql query

4 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Add your solution here

Preview 0

need help in sql query

4 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us