Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring Databases.SQL 7

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-16 : 09:30:41
Ray writes "Hi,
I have a realy hard error that I am stuck on if you can help.
While trying to restore a backed up datatbase in SQL Server 7 I receive the error.

"The media family on device XXX is incorrectly formed.
SQL Server cannot process this media family.

out of the 34 databases I have. 3 come back with this error while one restores perfectly.


Please help as I am really in Trouble.

Thanks in advance.

P.S... Microsofts page is crap !! It just recognises the error but no fixes.

Ray."

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-07-16 : 16:55:11
From crap.com

This article mentions SQL2000, but may be of use. Try Trace Flag 3111 like it suggests.
http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q297104



Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -