How do I attach a Database version downgraded in visual studio MS-SQL server

Question

1.00/5 (1 vote)

See more:

, +

I am using Visual Studio 2010, MS-SQL Server 2008 R2,
My project is using C# in asp web form.
I have two databases namely "test.mdf" and "database.mdf".
I already attached test.mdf and successfully working good.
But now when I attach database.mdf, it shows the following error.
Please, I help me out. I know only amateur(basic) level in asp.net.

Please click this link to see the error which it pops up.
http://goo.gl/egYsz3[^]

Posted 6-Sep-14 2:56am

Bharath Balu

Add a Solution

Comments

kbrandwijk 7-Sep-14 4:43am

Just for future reference, you are NOT using SQL Server 2008 R2 already, if you're getting that error message. Also in your own 'solution', you mention that you have now updated your SQL Server version. So this makes no sense at all.

Bharath Balu 7-Sep-14 4:51am

I am aware of what i was using. I used correct instance too. Still don't know why the error occured but I feel happy that I solved it.

3 solutions

Solution 2

The simple answer is that you cannot. You must upgrade to a later version of SQL Server.

Quote:
A database created by a more recent version of SQL Server cannot be attached or restored to an earlier version. This restriction is simply because an older version cannot know about file format changes that were introduced in the newer release.

Posted 6-Sep-14 3:02am

Mike Meinz

Updated 6-Sep-14 3:03am

v2

Comments

Bharath Balu 7-Sep-14 3:26am

Thank you so much Mike :)

Solution 1

See this page for the internal SQL Server version numbers: http://weblogs.sqlteam.com/dang/archive/2011/07/17/internal-sql-server-database-version-numbers.aspx[^].

The error shows that you are trying to attach a SQL Server 2008 database to a SQL Server 2005 SP2 instance. Make sure you have configured your connectionstring to point to the correct SQL Server instance running on your PC. You might have multiple instances running. Open the SQL Server Configuration Manager, and check the list under 'SQL Server Services' to see the instances running on your machine.

Posted 6-Sep-14 3:02am

kbrandwijk

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bharath Balu · Accepted Answer · 2014-09-06T21:34:00

Solution 3

I installed an updated version of SQL Server and it solved my problem. Thanks for your time to help me.

Posted 6-Sep-14 21:34pm

Bharath Balu