SQL database restore, the structure of the media family is incorrect, and SQL Server cannot handle one of the solutions for this media family.

Problem:

SQL database restore. The structure of the media family appears wrong, and SQL Server cannot process this media family.

Exceptions are for example with.

Solution to the problem:

The problem with sql2005 and sql2008 installed on my computer is that I opened the sql2005 instance with the sql2008 SQL Server Management Studio tool. You can view the current instance version number with the SELECT @ @VERSION statement.

For example with.

So finally the solution is to ensure that the connection instance is in a version greater than or equal to the version of the database being restored. You can restore success.

SQL database restore, the structure of the media family is incorrect, and SQL Server cannot handle one of the solutions for this media family.