Setup AdventureWorks Database In Microsoft SQL Server 2014

The AdventureWorks database is a sample database that is helpful for new users who are learning Relational Database Management System. This sample database contains database objects like tables, stored procedures, function, triggers, indexes and sample data. Whenever a new version of SQL Server is released, those newly added features are added to Sample Database.



In this blog, we will see how to setup AdventureWorks Database in Microsoft SQL Server.

Let's begin.

Visit this URL: https://msftdbprodsamples.codeplex.com to download AdventureWorks Database.

 

Click on "Adventure Works 2014 Full Database Backup.zip" link.

 

After downloading, extract the database backup file.

 
Open SQL Server (I am using SQL Server 2014) and right click on "Restore Database".

 

Select the device and click on the ellipses icon to select the backup media.

 

Click on Add button and select the backup file (Downloaded and extracted earlier in the above steps).

 

After selecting the database, click on "OK" button.

 

Click on "OK" button in "Restore Database" dialog.

 

 

Refresh the database folder. You have set the Adventure Database sample DB successfully.

 

Hope this will help you.

Thanks. 
Ebook Download
View all
Learn
View all