SQL database restore, the structure of the media family is incorrect, SQL Server cannot handle the resolution of this media cluster

Problem:

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

Exceptions are as follows.

Cause of 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. Use the SELECT @ @VERSION statement to view the current instance version. Such as.

So the final solution is to restore success by ensuring that the connection instance has a version number greater than or equal to the version number of the database to be restored.

SQL database restore, the structure of the media family is incorrect, SQL Server cannot handle the resolution of this media cluster