SQL Server 2008 to SQL Server 2005
sql-server-2008
Solution
I know what the problem is, it is quit descriptive error. but was asking the solution of that problem. anyway thanks to everyone for there reply.
anyone facing same problem, see the tread below and read LEKSS reply http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/46ce6099-61c6-4526-9dda-10a3359386cb
hope this will help
Update: Quoted external link for safe keeping
The database 'ASPNETDB.MDF' cannot 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 database publishing wizard to get out the 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
- Create a new empty database in your 2005 instance .
- Execute the above generated script in your new 2005 database.
- Move your SQL server logins/users from 2008 database to 2005 database using sp_help_revlogin stored procedure.
Thanks, Leks
Proposed As Answer byyup. _ Sunday, May 09, 2010 10:14 AM Marked As Answer byTom Li - MSFTMicrosoft, ModeratorThursday, May 20, 2010 4:58 AM
Problem
I have an MDF and LDF file of SQL Server 2005. i attached it with SQL Server 2008 and did some change in data. now when i attached it back to sql server 2005 Express Edition it gives version error. The database 'E:\DB\JOBPERS.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported. Could not open new database 'E:\DB\JOBPERS.MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database for file E:\DB\Jobpers.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.