How to fix the issue attach database mdf file not executing

Question

1.00/5 (1 vote)

See more:

SQL-Server-2014

I have MSSQL Server 2014 and want to attach mdf file its not executing and its complaining about the version of the mdf file being 852.

What I have tried:

SQL

<pre>CREATE DATABASE aspnetBookerDataSync20191202113733   
    ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\SQL Server\aspnet-BookerDataSync-20191202113733.mdf'),   
    (FILENAME = 'C:\Program Files\Microsoft SQL Server\SQL Server\aspnet-BookerDataSync-20191202113733_Log.ldf')   
    FOR ATTACH;

Posted 20-Feb-20 20:15pm

gcogco10

Updated 20-Feb-20 20:22pm

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2020-02-20T20:23:00

Two things:
1) Version 852 is SQL Server 2016, so earlier versions of the software can't open it. 2014 supports up to 782 only. You can't work round that, you need an earlier version of the DB file, or a later version of software. Do not that when you open a DB in a later version of software, it will be converted to the latest version automatically.

2) ATTACH is only available in Express versions of SQL Server - it's a debugging mode which isolates DB's from each other to prevent problems in dev. Production versions of the Server do not support it at all.