Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1056

Re: I get error when open a mdf file

Show all headers | View raw

On Monday, May 21, 2012 6:58:31 AM UTC-4, Tony wrote:
> Hello!
> 
> I use VS 2010 Professional and SQL Server 2008.
> SQL Server 2008 Express has version 10.0.2531 and the default instance has 
> version 10.0.1600.
> I have an mdf/ldf file that was created in VS 2008 for some time ago and I 
> don't know which SQL Server version this was created in.
> But when I try open this  CAMERA.MDF I get this errror see below. I have 
> tried the following.
> 1. Try to open from within VS using Server explorer
> 2.Try to attach from within SQL Server express and from the default 
> version(10.0.1600)
> but I get the same error. So I wonder how can I do to open this mdf database 
> file ?
> I use windows Vista.
> 
> The database 
> 'C:\USERS\TONY\PROGRAMMERING\ASPNET\KRISTIANSTAD\ASPDOTNET\MODULE3\APP_DATA\CAMERA.MDF' 
> cannot be opened because it is version 661. This server supports version 655 
> and earlier. A downgrade path is not supported.
> Could not open new database 
> 'C:\USERS\TONY\PROGRAMMERING\ASPNET\KRISTIANSTAD\ASPDOTNET\MODULE3\APP_DATA\CAMERA.MDF'. 
> CREATE DATABASE is aborted.
> An attempt to attach an auto-named database for file 
> C:\Users\Tony\programmering\aspNet\Kristianstad\ASPDOTNET\module3\App_Data\Camera.mdf 
> failed. A database with the same name exists, or specified file cannot be 
> opened, or it is located on UNC share.
> 
> //Tony

Tony, the error message seems to me to be identifying that the database file is at a higher version than your Express installation and that you need to upgrade (patch) your Express version to a higher version in order to be able to attach the database.

HTH -- Mark D Powell --

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

I get error when open  a mdf file "Tony" <johansson.andersson@telia.com> - 2012-05-21 12:58 +0200
  Re: I get error when open  a mdf file Mark D Powell <Mark.Powell2@hp.com> - 2012-05-21 06:15 -0700
    Re: I get error when open  a mdf file "Tony" <johansson.andersson@telia.com> - 2012-05-21 17:03 +0200
      Re: I get error when open  a mdf file "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-05-21 12:20 -0400
  Re: I get error when open a mdf file Erland Sommarskog <esquel@sommarskog.se> - 2012-05-21 23:33 +0200
    Re: I get error when open a mdf file Gene Wirchenko <genew@ocis.net> - 2012-05-21 15:49 -0700
      Re: I get error when open a mdf file Erland Sommarskog <esquel@sommarskog.se> - 2012-05-22 07:25 +0000

csiph-web