Click here to Skip to main content
13,052,669 members (63,171 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Plz sir tell me how i solve this problem.

The database 'F:\WEBSITE\WEBSERVICE\APP_DATA\PUBS2012.MDF' cannot be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported.
Could not open new database 'F:\WEBSITE\WEBSERVICE\APP_DATA\PUBS2012.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file F:\Website\WebService\App_Data\pubs2012.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Posted 7-Jan-13 1:08am
Zafar Sultan 7-Jan-13 7:18am
What exactly are you trying to do? Are you opening database created in SSMS 2012 using SSMS 2008?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You are trying to open a database created in (or upgraded to) a later version of SQL in an earlier version. Specifically, you seem to be trying to open an SQL 2012 database in Sql2008. You cannot do that - a database format can only be opened by the version of SQL that created it, or later than that. If you open a database in a later version, it is upgraded to the new format, and you cannot open in the original application again.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170713.1 | Last Updated 7 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100