SQL Server 2008 R2 Adventure Works Sample Databases.
-
venerdì 11 novembre 2011 07:44
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.
- Modificato Kushira venerdì 11 novembre 2011 07:44
Tutte le risposte
-
mercoledì 23 novembre 2011 04:49ModeratoreWhere 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 -
venerdì 2 dicembre 2011 06:19
Check This Link
Thank You,
Kushira.
- Modificato Kushira venerdì 2 dicembre 2011 06:20
-
mercoledì 2 maggio 2012 01:07Moderatore
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:
- Download AdventureWorks 2008 R2 OLTP Script.zip (http://msftdbprodsamples.codeplex.com/releases/view/59211)
- 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\.
- Open {SQL Server Path}\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql in SQL Server Management Studio.
- Update the script path variables.
- 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.
- Change the :setvar SqlSamplesSourceDataPath variable to the path containing the .csv files.
- Uncomment each :setvar variable.
- On the Query menu, click SQLCMD Mode.
- On the Standard toolbar, click the Execute button to run the script.
- Modificato Derrick VanArnam [MSFT]Microsoft Employee, Moderator mercoledì 2 maggio 2012 02:28
- Proposto come risposta Mr. WhartyMicrosoft Community Contributor, Moderator mercoledì 2 maggio 2012 03:25
- Contrassegnato come risposta Mr. WhartyMicrosoft Community Contributor, Moderator sabato 19 maggio 2012 01:52

