

After it completes, you will have the database WideWorldImporters installed on your SQL Server instance. Note that it is best practice to place data and log files on different drives. If needed, change the target location for the data and log files, in the Files pane.In the dialog Select backup devices, click Add, navigate to the database backup in the filesystem of the server, and select the backup.Select Device and click on the button.Right-click on the Databases node, and select Restore Database.Open SQL Server Management Studio and connect to the target SQL Server instance.To restore a backup to a SQL Server instance, you can use Management Studio.

Note that recreating the sample will result in slight differences in the data, since there is a random factor in the data generation: Source code to recreate the sample database is available from the following location. For the best results use the June 2016 release or later.ĭownload the sample WideWorldImporters database backup/bacpac that corresponds to your edition of SQL Server or Azure SQL Database.
#Download and install sql server 2014 express full version
For the Full version of the sample, use SQL Server Evaluation/Developer/Enterprise Edition. SQL Server 2016 (or higher) or Azure SQL Database.

Wide World Importers OLTP database installation and configuration instructions. Applies to: SQL Server (all supported versions) Azure SQL Database
