Installing Sample Databases
To install all the sample databases for SQL Server 2008 perform the following steps:
- Using the object explorer in SSMS delete any earlier version of the AdventureWorks sample databases you may have installed.
- Using the file explorer ensure all .MDF and .LDF files have been deleted from the data directory for all sample databases in the instance you will be installing the new sample databases. For the default instance, the path to the data directory for OLTP, LT, and DW sample databases is typically C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA.
- Click on the appropriate MSI file for your architecture of machine. For example, for x64 architecture machines click on the link for SQL2008.AdventureWorksAllDatabases.x64.msi.
- Respond to all the dialogs presented by the installer as detailed below.