Sunday 29 March 2020, by Younus Kazi
The AdventureWorks database is one of the sample databases that were published by Microsoft to show how to design a SQL Server database using SQL Server. This tutorial shows how to download and restore this sample database in Microsoft SQL Server 2017.
Download AdventureWorks2017.bak
Start SQL Server Management Studio (SSMS)
![](images/1072/01_start_ssms.png)
Right click on the Database and click on ‘Restore Database..’ from the context menu.
![](images/1072/02_right_click.png)
On the Restore Database window select Device and click the ellipsis button with three dots top open the ‘Select backup devices’ dialog box.
![](images/1072/03_restore_database.png)
Click the Add button.
![](images/1072/04_select_backup_devices.png)
If the backup file AdventureWorks2017.bak is not in the default backup folder then bring the AdventureWorks2017.bak here. If you don’t do this, then backup may fail for security reason.
![](images/1072/05_locate.png)
Copy the Backup File location and paste it in a new File Explorer window.
![](images/1072/06_move_backup.png)
Copy the backup file here.
![](images/1072/07_copy_in_the_folder.png)
In SSMS, close the Locate Backup File window and open it again. The AdventureWorks2017.bak will be appeared here. Select the backup file and click the OK button.
![](images/1072/08_select_backup_file.png)
On the Select backup devices window, click the OK button.
![](images/1072/09_selected.png)
On the Restore Database window, make sure the Restore option is checked and click the OK button.
![](images/1072/10_ready_to_restore.png)
The backup file will be restored within few seconds and a message box will confirm that the database restored successfully.
![](images/1072/11_restored.png)
The new AdventureWorks2017 database will be shown into the Databases node.
![](images/1072/12_done.png)