AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server

Q

How to download and install the scaled-down database AdventureWorksLT in SQL Server?

✍: FYIcenter.com

A

If you want to practice you DBA skills with the scaled-down version of the sample database AdventureWorksLT provided by Microsoft, you should follow this tutorial to download and install it first:

1. Go to the SQL Server 2005 Samples and Sample Databases download page.

2. Go to the x86 section in the Instructions section, Click "AdventureWorksLT.msi -- 2,251 KB" to download the sample file. Save the download file to c:\temp.

3. Double click on the downloaded file: c:\temp\AdventureWorksLT.msi. The installation setup window shows up. Follow the instructions to finish the installation.

When the installation is done, two physical database files are installed in the data directory: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data:

AdventureWorksLT_Data.mdf   5,120 KB
AdventureWorksLT_Log.ldf    2,048 KB

 

Attaching AdventureWorksLT Physical Files to the Server in SQL Server

Downloading and Installing SQL Server Sample Scripts in SQL Server

Installing Sample Scripts and Databases in SQL Server

⇑⇑ SQL Server Database Tutorials

2019-08-04, 12714🔥, 1💬