SQL Server 2008 - SQL Server 2005

Question

I have a SQL Server 2005 MDF and LDF file. I linked it to SQL Server 2008 and made some changes to the data. now that I have linked it back to SQL Server 2005 Express Edition, it gives a version error.

Database 'E: \ DB \ JOBPERS.MDF' could not be opened because it is version 655. This server supports version 612 and earlier. The downgrade path is not supported. Failed to open new database 'E: \ DB \ JOBPERS.MDF. CREATE DATABASE is interrupted. An attempt to automatically name a database for the file E: \ DB \ Jobpers.mdf failed. A database with the same name or the specified file cannot be opened or it is located on a UNC share.

Answer 1

I know what the problem is, this is a wonderful descriptive error. but asked to solve this problem. Anyway, thanks to everyone for the answer.

anyone is facing the same problem, see the patronage below and read the LEKSS answer http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/46ce6099-61c6-4526-9dda-10a3359386cb

hope this helps

---

Update: quote external link for safe storage

Database "ASPNETDB.MDF" could not be opened because it is version 655. This server supports version 612 and earlier.

You cannot backup / restore or detach / attach from a higher version to a lower version.

• Use the database publishing wizard to get a script for all objects in 2008 db

http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
http://blogs.msdn.com/webdevtools/archive/2007/10/15/sql-database-publishing-wizard-is-now-in-visual-studio-orcas.aspx
http://msdn.microsoft.com/en-us/library/bb895179.aspx

2. Create a new empty database in your 2005 instance.
3. Run the script created above in the new 2005 database.
4. Transfer your SQL Server logins / users from the 2008 database to the 2005 database using the sp_help_revlogin Procedure.

Thanks Lex

Suggested as an answer byyup. _ Sunday, May 09, 2010 10:14 AM
Marked as reply byTom Li - MSFT Microsoft, ModeratorThursday, May 20, 2010 4:58 AM

Answer 2

MDF and LDF now have version 655 (SQL version 2008). As the error message clearly states, there is no possibility of downgrading. From now on, you can only attach these files to SQL Server 2008 or SQL Server 2008 R2 (which will upgrade them to 661 battles). You can never attach these files to an instance of SQL 2005.

Answer 3

I know this was answered, but this question solved the problem for me:

database-cannot-be-opened-because-it-is-version-655

basically remove "\ SQLEXPRESS" from the connection string value. instead: Data source =. \ SQLEXPRESS ; AttachDbFilename = | DataDirectory | \ OTJDB.mdf; Integrated Security = True; User Instance = True

usage: data source =; AttachDbFilename = | DataDirectory | \ OTJDB.mdf; Integrated Security = True; User Instance = True

Answer 4

This is because file formats are fundamentally different. If you attach the file to SQL Server 2008, you MUST upgrade your express version to leas. The version to which you last attached the file.

So, you have only 2 options: update or cut the file and update your updates in the 2005 installation.

Answer 5

This is a one-way street, you can always give up disgust, but never give up the version, this is due to changes in metadata.

Answer 6

The man also faced this problem. But here is an even simpler way to do this:

I made a copy of my source .MDF DB file from my source files on my development machine, where I back up all my .MDF files using earlier versions of Visual Studio, and then copied the file directly to the server, since I have direct access to my server.

I just pasted the file on the Inetpub server, where the App_Data folder for my site files and voila! More compatibility issues.

Then, using SQL Server Management Studio, re-attach the DB file you just pasted into Inetpub and it will work!