Restoring AdventureWorks2019 Database

Restoring AdventureWorks sample databases

In this post I will show steps to download AdventureWorks sample databases, and steps for restoring database on our SQL Server.

search "download adventureworks database" in google and click on the first link (docs.microsoft.com)

When we click, we will get a page like this

We will find three types of files :

OLTP data is for most typical online transaction processing workloads.

Data Warehouse (DW) data is for data warehousing workloads.

Lightweight (LT) data is a lightweight and pared down version of the OLTP sample.

At this stage we will download OLTP AdventureWorks2019.bak

Now we will open the SSMS and restore the database that we have downloaded. As we can see, we have only system databases.

I am going to click right on databases and Restore Database 

Now, we will get a dialog box like this. It looks bit complicated. Click on the device and press three dot button, we will get a new window like below

Now we need to add the Media and we need to find where we have saved it. We have saved our file in D:\AdventureWorks

Now click and we can see that source database name is AdventureWorks2019 and destination database name is AdventureWorks2019 (if we want, we can write new name in destination database) 

Press Ok and our database has been restored

We can see AdventueWorks2019 database in under the list of databases.