1

I am facing a problem while attaching a SQL Server 2005 database to a SQL Server 2012 instance. Is there way to solve this problem?

enter image description here

Improve this question
13
  • whats the error you're getting? What do you mean by Attach? Commented Mar 13, 2014 at 14:33
  • hi bro I got this error tinypic.com/view.php?pic=igg46t&s=8#.UyHCNtySw0Y Commented Mar 13, 2014 at 14:35
  • 2
    Well the message appears pretty obvious. Can't you recreate the database and then import its structure and data from the original sql server 2005 instance? Commented Mar 13, 2014 at 14:38
  • +1 Crono. The message tells you how to fix: "You must re-create the database." You'll need to use SQL 2005 to either backup the database, or export as scripts. Commented Mar 13, 2014 at 14:40
  • 1
    Some more info: Normally you can attach a 2005 database (internal version no 611) in a 2012 SQL Server. But the 2005 database version you've got is 603. That's a "non-release version" as it says and older than the at least required version. Probably the database was created using a pre-release beta version of SQL Server 2005. Commented Mar 13, 2014 at 15:06

1 Answer 1

Reset to default
1

It looks like you may need to two-step the process. That is, build a SQL 2008 or 2008R2 instance, attach your database there, detach, then attach to your 2012 instance.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.