Answers

Question and Answer:

  Home  MS SQL Server

⟩ How to download and install the scaled-down database AdventureWorksLT?

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: emp.

3. Double click on the downloaded file: c: empAdventureWorksLT.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 FilesMicrosoft SQL ServerMSSQL.1MSSQLData:

AdventureWorksLT_Data.mdf 5,120 KB

AdventureWorksLT_Log.ldf 2,048 KB

 137 views

More Questions for you: