AdventureWorks

This article provides direct links for downloading

sample databases and

instructions for restoring them to your database.

For more information about samples, see the

Samples GitHub repository.

Management Studio (SSMS)

MSSQL extension for Visual Studio Code

Use these links to download the appropriate sample database for your scenario.

data works for most typical online transaction processing workloads.

data works for data warehousing workloads.

data is a lightweight and pared down version of the

sample.

If you’re not sure what you need, start with the OLTP version that matches your SQL Server

version.

AdventureWorks2025.bak

AdventureWorksDW2025.bak

AdventureWorksLT2025.bak

AdventureWorks2022.bak

AdventureWorksDW2022.bak

AdventureWorksLT2022.bak

AdventureWorks2019.bak

AdventureWorksDW2019.bak

AdventureWorksLT2019.bak

AdventureWorks2017.bak

AdventureWorksDW2017.bak

AdventureWorksLT2017.bak

AdventureWorks2016.bak

AdventureWorksDW2016.bak

AdventureWorksLT2016.bak

AdventureWorks2016_EXT.bak

AdventureWorksDW2016_EXT.bak

N/A

AdventureWorks2014.bak

AdventureWorksDW2014.bak

AdventureWorksLT2014.bak

AdventureWorks2012.bak

AdventureWorksDW2012.bak

AdventureWorksLT2012.bak

ﾉ

Expand table

AdventureWorks