Click here to Skip to main content
11,583,532 members (67,636 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: ASP.NET SQL Server
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 at 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
0 OriginalGriff 390
1 Dave Kreskowiak 230
2 Sergey Alexandrovich Kryukov 210
3 virusstorm 209
4 Richard Deeming 180
0 OriginalGriff 1,523
1 Sergey Alexandrovich Kryukov 995
2 Abhinav S 696
3 Dave Kreskowiak 621
4 Suvendu Shekhar Giri 568

Advertise | Privacy | Mobile
Web03 | 2.8.150603.1 | Last Updated 7 Jan 2013
Copyright © CodeProject, 1999-2015
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