Adventure works 2014 free download

In the Restore Database window, select Device as a source and click on ellipse … :. In the Locate backup devices window, select the backup media by clicking Add , and then in the newly opened window navigate to the directory where the database backup is downloaded and select the backup.

Click OK :. If you want to change the physical location of the data file and log file, click on Files pane and change the target location for the data and log files.

Note that it is best practice to keep data files and log files on separate drives:. Click OK. It will initiate the database restoring process.

Once the database restores successfully, a popup appears stating that the database has been restored successfully. We can also prepare the database by executing the database installation script on SQL Server. To do that, first, you must download the installation scripts of AdventureWorks and AdventureWorksDW databases.

Device option enables you to point to the storage device where the database backup is stored. Click on the " If the current place is not listed in the existing devices, press on Add button. Approve all settings and return back to initial Database Restore screen. You will see that as the Destination Database, AdventureWorks is already set automatically after the backup file selection. We need to click on the Add button. In the Locate Backup File window, navigate to your database instance's Backup folder.

Select the appropriate backup file. As shown here AdventureWorks Click on AdventureWorks This will return you to the Select backup devices window. In the Select backup devices window, the path and filename to AdventureWorks In the Restore Database window, the database name will be populated. Click on OK to begin the restoration process. A progress bar will appear at the top of the window. If the AdventureWorks database does not appear, right-click on Databases and choose Refresh.

Similar steps can be followed to restore the AdventureWorksDW database to your computer. Also, check out the following tips on database backup and restoration.