« previous next »
Pages: [1]

Author Topic: How does one get the adventureworks test database running?  (Read 1118 times)

0 Members and 1 Guest are viewing this topic.

Offline AxeiaTopic starter

  • Devotee
  • Posts: 716
  • Gender: Male
    • View Profile
How does one get the adventureworks test database running?
« on: February 25, 2010, 03:03:55 AM »
How does one actually get this adventureworks database installed on SQL Server 2005? There is a nice MSI here: http://msftdbprodsamples.codeplex.com/releases/view/4004 but it fails to add any kind of database and it doesn't seem to install anything. (it doesn't provide any info of what files it's searching where and searching my disk for 'adventureworks' only finds the installer itself)

If needed I could try to get one of my classmates to dump it to a file, but it seems there is no dump command.. and the restore/backup options offered within management studio 2005 express only seem to work for your own files. (as in, a restore requires a database to already exist.. and if you try to create it and then 'restore' from a file, it doesn't work).
Logged
Post PHP code like this: [php]#PHP code goes here.[/php]
And everything else like: [code]//codes goes here.[/code]

Offline Brian Swan

  • Irregular
  • Posts: 47
    • View Profile
Re: How does one get the adventureworks test database running?
« Reply #1 on: March 12, 2010, 05:03:55 PM »
I think all the .msi does is to lay down the .mdf and .ldf files. You still have to attach the database after that. If you have SQL Server Management Studio, here are instructions for attaching a database: http://msdn.microsoft.com/en-us/library/ms190209.aspx

Hope that helps.

-Brian
Logged
Pages: [1]
« previous next »