Download and Install AdventureWorks Sample Database
In this blog, we will learn how to Download and Install AdventureWorks Sample Database. We will be using AdventureWorks2017.bak database.
Same steps are applicable to restore any database from the backup.
Error – No backupset selected to be restored
If you get an error – “No backupset selected to be restored”, it means that you have an older version of the SQL Server database. To install SQL Server 2019 visit Install SQL Server 2019 on Windows 10.
Steps to Download and Install AdventureWorks database
- Download AdventureWorks database using the link AdventureWorksDW2017.bak
- Launch SQLServer Management studio (SSMS) and connect. Look for SSMS install steps in case you need one.
- Right click on the Databases and select Restore Database.
4. On the Restore Database dialogue, navigate to your downloaded database backup file by selecting Device
It will take you to the default backup directory –
C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup
You can change it to your backup download folder.
5. Select OK in the next screens.
6. Select OK here and your backup is now restored. It can be seen in your Management Studio Object explorer