Error attaching Adventureworks 2008 db to SQL Server 2008 [not R2]

Question

Hi ppl,

I have SQL Server 2008[NOT R2] installed in my laptop [Windows Vista Home Premium, 64 bit].

There are 2 issues:

1. Downloaded the AdventureWorks 2008_SR4 from the link :  http://msftdbprodsamples.codeplex.com/releases/view/37109 .

but wasn't able to install it due to an error - database Installer stopped working and had to close the program.

Hence my friend installed it his laptop and sent me the .mdf and .ldf files.

2. I tried attaching the databases using SSMS2008, but it is showing Error:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'xxxxxx'.  (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'AdventureWorksDW2008' 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 'AdventureWorksDW2008'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476
------------------------------
BUTTONS:

OK
------------------------------

I have checked the version of sql server opened in SSMS and it is 2008 itself

I cannot find any other Non R2 AdventureWorks file for 2008.

Any help would be appreciated greatly.

Thanks,

Chips.

Answer 1

I have SQL Server 2008[NOT R2] installed in my laptop [Windows Vista Home Premium, 64 bit].

...

The database 'AdventureWorksDW2008' cannot be opened because it is version 661. This server supports version 655 and earlier.

Hello Chips,

database version 655 is SQL Server 2008, 661 is SQL Server 2008 R2, so your friend send you a database file of a newer version, which you can't attach to a older version. I guess your friend uses 2008R2, the database is upgraded automatically to this version.

Have a deeper look at CodePlex, Version 2008 is still available there.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

did you check the prerequisite wiki page for AdventureWorks 2008 DB ?

Installation Prerequisites for the SQL Server 2008 and 2008R2 Sample Databases

Answer 3

Hello Olaf Helper,

Thanks for the reply.

I needed to clarify something, since you mentioned that - 'I guess your friend uses 2008R2, the database is upgraded automatically to this version.' -  If the AdventureWorks 2008 version application is run on SQL Server 2008 R2 version , will it be automatically upgraded to the 2008 R2 version so that the data file of the AW db obtained after running the above application would be eventually that of 2008 R2 version?

Thanks,

Chips.

---

LM

Answer 4

Hello Daniel,

Yes, I have checked all the pre-requisites mentioned here before installing.

Thanks for the reply.

Regards,

Chips.

---

LM

Answer 5

Yes. Once you used DB on a newer version of SQL Server, you will not be able to use it on a lower version.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 6

Hi All,

Thanks for the replies.

Appreciate it.

Thanks,

Chips.

---

LM