SQL Server 2008 R2 Adventure Works Sample Databases.

Question

I downloaded Adventure Works sample databases installation package for sql server 2008 r2 and installed it.It asked for my server instance which is 'Kushira'. Then it extracts whole lot of files to the selected location.From then onwards what should i do, i can't run any script they are giving me lot of errors. Errors telling that he can't create mdf and log files.

can anyone please explain how to install these databases in order to learn analysis services to my work.

Thank You.

Answer 1

Where did you download the package from?  What scripts are giving you errors?

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

Check This Link

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/a2806e43-c375-49c5-abde-3259848045d2

Thank You,

Kushira.

Answer 3

We uploaded an AdventureWorks 2008 R2 OLTP database and script to CodePlex (http://msftdbprodsamples.codeplex.com/releases/view/59211). Orhttp://msftdbprodsamples.codeplex.com and click on the SQL Server 2008 R2 OLTP tile.

Hopefully, this version is easier to attach and use.

As long as you copy the database to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\DATA, you should be able to attach the AdventureWorks2008R2_Data.mdf database. You will need to remove the transaction log reference.

Or you can run the setup script. Follow these steps to install the sample database from the script:

1. Download AdventureWorks 2008 R2 OLTP Script.zip (http://msftdbprodsamples.codeplex.com/releases/view/59211)
2. Copy the DDL script files to any path such {SQL Server Path}\Tools\Samples\AdventureWorks 2008 OLTP Script.
   
   Note The default SQL Server 2008 R2 path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\.
   
3. Open {SQL Server Path}\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql in SQL Server Management Studio.
4. Update the script path variables.
5. If necessary, change the :setvar SqlSamplesDatabasePath variable to your SQL Server 2008 R2 path. The default path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA.
6. Change the :setvar SqlSamplesSourceDataPath variable to the path containing the .csv files.
7. Uncomment each :setvar variable.
8. On the Query menu, click SQLCMD Mode.
9. On the Standard toolbar, click the Execute button to run the script.