Download and Deploy AdventureWork Sample Database

What is Adventurework?

Microsoft offers the same database to work on SQL Developer or DBA activities. By using this database, we can do our regular activities which are related to SQL Developer and DBA activities. (Example Create / ALTER / DROP / Backup / Restore…etc… )

Where we can download the Adenturework Database? We can download the database as .bak format file from Microsoft official website ( Link )

Here I have provided the direct link to download the Adventurework Sample database, We have three types of sample database bak files below.

1. OLTP data is for most typical online transaction processing workloads.
2. Data Warehouse (DW) data is for data warehousing workloads.
3. Lightweight (LT) data is a lightweight and pared-down version of the OLTP sample.

OLTP	Data Warehouse	Lightweight
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
AdventureWorks2008R2.bak	AdventureWorksDW2008R2.bak	N/A

Restore AdventureWorks Database to SQL Server

Step : 1 : Right click Database in Object Explorer > Restore Database

Step 2 : Select Device and then select the ellipses (..) to choose a device.

Step 3 : Select Add and then choose the .bak file from your recently download .bak file.

Now we can successfully Db restored…!

For More Information, Visit Microsoft Link

Thank You..! Please like and share with your friends.