I am using SQL Server 2008 express and i want to import .mdf and i get this error: .mdf version is 661, your db supports the version 655
Which version is 661 and how to import it in sql Server 2008.
A:
Express 2008 - like without any service pack? Try getting your hands on the latest express version (they did not get service packs, but new installers) and install that. Chance we talk about 2008 R2 express, which should run around somewhere as beta?
TomTom
2010-03-17 14:21:20
hmm i have sp1. In company we have enterprise version with sp1 also but the same error. Any other idea?
senzacionale
2010-03-17 22:48:50
found correct version 2008 r2 NOV CTP.
senzacionale
2010-03-18 08:43:27
+1
A:
Version 661 sounds like the format used by server 2008 R2 so it looks like someone has installed the beta and then attached your DB to it.
See this link for some more details
http://www.sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx
Kevin Ross
2010-03-18 08:23:17
+1
A:
Install SQL Server 2008 EXPRESS R2. There is a bug in the Web Platform Installer and it still thinks EXPRESS R1 is the latest version.
basilmir
2010-07-07 14:50:14