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
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
No comments:
Post a Comment