Restoring AdventureWorks2017 and AdventureWorksDW2017 Databases

 

Restoring AdventureWorks2017 and AdventureWorksDW2017 Databases

Restoring the AdventureWorks sample databases

In this post we would see the steps to download/Update 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)

As we click, the following page comes up

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.

We would download OLTP and also DW 

AdventureWorks2017.bak

AdventureWorksDW2017.bak

Now we will open the SSMS and restore the database that we have downloaded. As we can see, we have different databases but not AdventureWorks.

Right on databases and Restore Database 

A dialog box pops up as below...

Click on the device and press three dot button, we will get a new input box

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

Select the file by using the ADD button in the input box each at a time

Post clicking ok we can see that source database name is AdventureWorks2019 and destination database name is AdventureWorks2017 (if we want, we can write new name in destination database) 

Press Ok and our database has been restored

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

We need to follow the same steps to restore the AdventureWorksDW2017

We can see the AdventureWorksDW2017 as well in the Database list as below

It was easy right to restore the Database, you can restore any number of Database as you want.

All the best !!!