How to load AdventureWorks into Microsoft SQL Server Management Studio

STEP ONE:

Ensure you have downloaded the database file on your system. If you have not, click here download here and choose a version

Screenshot 2022-09-19 at 12.48.37.png

STEP TWO:

download folder.PNG

copy the file from your download folder and paste it in the windows folder. This PC > Local Disk(C:) > Windows windows.PNG So the Windows folder should look like this

pasteADW.PNG

STEP THREE:

Open the Microsoft SQL Server Management Studio (this could take a few seconds before it comes up)

SQL Server Connect.PNG Connect to the server

Connected.PNG Right Click on Databases on the left panel and click on Restore databases.

Screenshot (2).png

edited.png A new window will open Click on Add

Click on Add.PNG

Use the scroll to navigate to the side for more options

Adw found.PNG Click on the Adventureworks file and then Okay

Okay.PNG

Click Okay

backup.PNG

Click Okay

Okay2.PNG

You should see a successful message been displayed on your screen.

successful.PNG

Go to the left panel on your screen and open Databases, You should find the just loaded file in there.

Check database.PNG