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

Groups > comp.databases.ms-sqlserver > #1658 > unrolled thread

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

Back to article view | Back to comp.databases.ms-sqlserver

Contents

  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

#1658 — I get errror message when trying to use mdf database downloaded from the net

I want to use the downloaded mdf database but I get this error.

The database 
'C:\USERS\TONY\PROGRAMMERING\ENTITYFRAMEWORKTEST\ENTITYFRAMEWORKTEST\ENTITYFRAMEWORKTEST\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 
'C:\USERS\TONY\PROGRAMMERING\ENTITYFRAMEWORKTEST\ENTITYFRAMEWORKTEST\ENTITYFRAMEWORKTEST\APP_DATA\PERSONDB.MDF'. 
CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file 
C:\Users\tony\programmering\EntityFrameworkTest\EntityFrameworkTest\EntityFrameworkTest\App_Data\personDb.mdf 
failed. A database with the same name exists, or specified file cannot be 
opened, or it is located on UNC share

Here is the version I have for my SQl Server 2008
Microsoft SQL Server Management Studio      10.0.1600.22 
((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools      2007.0100.1600.022 
((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)      6.0.6002.18005 
(lh_sp2rtm.090410-1830)
Microsoft MSXML      3.0 5.0 6.0
Microsoft Internet Explorer      9.0.8112.16421
Microsoft .NET Framework      2.0.50727.4241
Operating System      6.0.6002

You experts what is the best I can do to use the downloaded mdf database?

//Tony 

[toc] | [next] | [standalone]

#1659

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

[toc] | [prev] | [next] | [standalone]

#1660

On Sunday, 9 February 2014 14:21:14 UTC, Erland Sommarskog  wrote:
> 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.

However, if the objects in the database don't require the 
features of SQL Server 2008 R2, then someone could produce
scripts to create the same objects in an earlier version
database.  

Tools such as "SQL Compare" and "SQL Data Compare" can copy
objects between two servers - although they're pretty expensive,
and in my unsophisticated experience with them, copying all 
the objects in a database isn't straightforward - they are 
really designed for finding and reconciling small differences, 
and they may sometimes get the dependencies, the order of 
creating objects and loading data wrong.

And you can do it without them, but it takes longer.  In any
case, it would need to be done with access to a 2008 R2 server
or later.  But the output can be in the form of scripts, too,
to use on /your/ system.  But unfortunately I can't offer to
do it.  (Unless there is really good stuff in this database.)

I think Microsoft documentation says somewhere that restoring
or mounting a database that you got from a stranger can be 
quite a bad idea; it could have all sorts of bad things in it -
viruses, malware.  Depending on version, SQL Server apparently
invests a lot of trust in any database on the server.

[toc] | [prev] | [next] | [standalone]

#1661

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 

[toc] | [prev] | [next] | [standalone]

#1663

Tony Johansson (johansson.andersson@telia.com) writes:
> 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.

I would rather install an instance of SQL 2012. Or be brave and install
the current CTP of SQL 2014. It all depends on why you have SQL Server
installed in the first place.
 
> If I install SQL 2008 R2 how will that effect current databases that I
> have in my present SQL Server 2008. 

If you upgrade your current instance, your database with be upgraded
to the format of SQL 2008 R2. However, you don't need to do an upgrade,
but you could install a second instance and in this case, the databases
you have on SQL 2008 will not be affected.



-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

[toc] | [prev] | [next] | [standalone]

#1667

I'm not so good at databases. Can somebody guide me to the correct home page
to use to download the SQL Sever R2 verison

//Tony



"Erland Sommarskog" <esquel@sommarskog.se> skrev i meddelandet 
news:XnsA2CFBC5CB9413Yazorman@127.0.0.1...
> Tony Johansson (johansson.andersson@telia.com) writes:
>> 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.
>
> I would rather install an instance of SQL 2012. Or be brave and install
> the current CTP of SQL 2014. It all depends on why you have SQL Server
> installed in the first place.
>
>> If I install SQL 2008 R2 how will that effect current databases that I
>> have in my present SQL Server 2008.
>
> If you upgrade your current instance, your database with be upgraded
> to the format of SQL 2008 R2. However, you don't need to do an upgrade,
> but you could install a second instance and in this case, the databases
> you have on SQL 2008 will not be affected.
>
>
>
> -- 
> Erland Sommarskog, Stockholm, esquel@sommarskog.se 

[toc] | [prev] | [next] | [standalone]

#1668

Tony Johansson (johansson.andersson@telia.com) writes:
> I'm not so good at databases. Can somebody guide me to the correct home
> page to use to download the SQL Sever R2 verison 

Which edition do you want? Not all editions come for free. Anyway:
http://www.lmgtfy.com/?q=%22SQL+Server+2008+R2%22+download

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

[toc] | [prev] | [next] | [standalone]

#1662

I'm not so good at databases. Can somebody guide me to the correct home page 
to use to download the SQL Sever R2 verison

//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 

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web