Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Is it possible to install adventureworks 2012 database inside SQL server 2008 R2? Expand / Collapse
Posted Friday, September 27, 2013 1:07 AM


Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:51 PM
Points: 183, Visits: 480

I tried doing that and got an incompatibility error. I was wondering if there is a workaround or fix for that or if there is a 2012 DB for SQL 2008.

The error message is -
TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'YourComputer'. (Microsoft.SqlServer.Smo)

For help, click:


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:
Post #1499220
Posted Friday, September 27, 2013 1:20 AM



Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 15,499, Visits: 13,162
There are also sample databases available for earlier versions of SQL Server.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1499224
Posted Friday, September 27, 2013 1:56 AM



Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 45,619, Visits: 44,147
You'll need to download a SQL 2008 or earlier adventureworks. The 2012 one is a 2012 database and hence can only be restored to SQL 2012 or newer.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1499239
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse