I am using MSSQL Server Mgmt Studio 2008.
I haven't worked with MSSQL Server in 10 years. Back then it was MSSQL Server 2000. I have MSSQL Server 2008 Express installed on a Windows-7 PC. I am trying to restore a DB provided by a client from a backup named MP.BAK. The attached screen shot error message is telling me that the client backed up the DB with a newer version of MSSQL Server than the one I am using. So should I uninstall MSSQL Server 2008 Express and replace it with a newer version of MSSQL Server Express? If so which one? 2010 or 2012?. Is there a work-around that will allow me to restore from a new version to an older version?
No need to answer every question. Just a solution that will work.