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


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

Re: I get errror message when trying to use mdf database downloaded from the net

From "Tony Johansson" <johansson.andersson@telia.com>
Newsgroups comp.databases.ms-sqlserver
Subject Re: I get errror message when trying to use mdf database downloaded from the net
Date 2014-02-09 15:54 +0100
Organization A noiseless patient Spider
Message-ID <ld84r0$ih2$1@dont-email.me> (permalink)
References <ld7sjh$6st$1@dont-email.me> <XnsA2CF9C30C3C8BYazorman@127.0.0.1>

Show all headers | View raw


So you mean that my current version of SQL Server 2008 is too old for the 
mdf file database.
So I should install SQL 2008 R2. Is that what you mean.

If I install SQL 2008 R2 how will that effect current databases that I have 
in my present SQL Server 2008.

//Tony


"Erland Sommarskog" <esquel@sommarskog.se> skrev i meddelandet 
news:XnsA2CF9C30C3C8BYazorman@127.0.0.1...
> Tony Johansson (johansson.andersson@telia.com) writes:
>> The database
>> 'C:\USERS\TONY\PROGRAMMERING\ENTITYFRAMEWORKTEST\ENTITYFRAMEWORKTEST\ENTI
>> TYFRAMEWORKTEST\APP_DATA\PERSONDB.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
>
> The database file is from SQL 2008 R2. You have SQL 2008. You would need
> to install a newer version of SQL Server to use the datbase file.
>
>> Here is the version I have for my SQl Server 2008
>> Microsoft SQL Server Management Studio      10.0.1600.22
>> ((SQL_PreRelease).080709-1414 )
>
>
> And this the RTM version of SQL Server Management Studio, so even if
> you decide to stick with the current version, you should install
> Service Pack3.
>
> -- 
> Erland Sommarskog, Stockholm, esquel@sommarskog.se 

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


Thread

I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-09 13:33 +0100
  Re: I get errror message when trying to use mdf database downloaded from the net Erland Sommarskog <esquel@sommarskog.se> - 2014-02-09 15:21 +0100
    Re: I get errror message when trying to use mdf database downloaded from the net rja.carnegie@gmail.com - 2014-02-09 06:42 -0800
    Re: I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-09 15:54 +0100
      Re: I get errror message when trying to use mdf database downloaded from the net Erland Sommarskog <esquel@sommarskog.se> - 2014-02-09 18:31 +0100
        Re: I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-10 23:18 +0100
          Re: I get errror message when trying to use mdf database downloaded from the net Erland Sommarskog <esquel@sommarskog.se> - 2014-02-10 23:38 +0100
    Re: I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-09 16:42 +0100

csiph-web