error while attaching adventureworks in 2008r2

Question

error while attaching adventureworks in 2008r2

harri.reddy

SSCommitted

Points: 1957
More actions
September 8, 2012 at 5:53 pm

#261701

hi
i am getting following error while attaching mdf file in my SSMS.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'AdventureWorks2012' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks2012'. 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
------------------------------
Any help?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

You cannot attach to a SQL Server 2012 database from an earlier version of SQL Server. Download the Adventure Works for your particular version of SQL Server from CodePlex.

HTH,

Rob

Sean Pearce SSCoach Points: 15999 More actions · Answer 2

Other way. You cannot attach a 2012 database onto an earlier version.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

harri.reddy SSCommitted Points: 1957 More actions · Answer 3

i am attaching 2008r2 version to my sql server 2008r2

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

AdventureWorks2012 as listed in your error message is 2012

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

CapnHector SSCoach Points: 16143 More actions · Answer 5

i found installing from the script file was the easiest for me. i had to go and remove any full text stuff as i dont have full text indexing installed on my dev machine.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]