I have a problem when attaching the file
AdverntureWorksLT2008R2_Data.mdf to Microsoft SQL Server Management Studio (SSMS).
The database 'AdventureWorksLT2008R2' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'AdventureWorksLT2008R2'. CREATE DATABASE is aborted. )Microsoft SQL Server, Error: 948)
So, I was wondering if it is possible to do something on the
.mdf file so that the
.mdf file will be downgrade to version 655 or earlier.
There is a similar question(s) such as this - Attaching database to the SQL server
The correct answer mention about getting to know more about the version and one suggest that latest Service Pack must be installed.
I have checked the version and notice that the latest Service Pack have been installed.
So, I was thinking of downgrade the mdf file but how do I downgrade it?