Jump to content

How does one get the adventureworks test database running?


Axeia

Recommended Posts

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).

  • 3 weeks later...

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.