Last year, I have written a blog to install sample database WideWorldImporters SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters. Recently, while I was showing demo to a client, they informed that I don’t have a blog about data-warehouse database WideWorldImportersDW. In this blog we would learn about how to install database WideWorldImportersDW.bak
Step 1: Download the backup file “WideWorldImportersDW-Full.bak” from below location wide-world-importers-release
If you are using Standard Edition of SQL Server, then few feature will not work. In that case you need to download file WideWorldImportersDW-Standard.bak
Step 2: Create a folder on C drive called “WWI_DW”. If you want to use some other drive/folder, then you can do that also. Whatever path/folder you create, replace that in below step 3.
Step 3: Run below script in SSMS.
USE [master] RESTORE DATABASE [WideWorldImportersDW] FROM DISK = N'C:\WWI_DW\WideWorldImportersDW-Full.bak' WITH FILE = 1, MOVE N'WWI_Primary' TO N'C:\WWI_DW\WideWorldImportersDW.mdf', MOVE N'WWI_UserData' TO N'C:\WWI_DW\WideWorldImportersDW_UserData.ndf', MOVE N'WWI_Log' TO N'C:\WWI_DW\WideWorldImportersDW.ldf', MOVE N'WWIDW_InMemory_Data_1' TO N'C:\WWI_DW\WideWorldImportersDW_InMemory_Data_1', NOUNLOAD, STATS = 5 GO
Once completed, you should see database in SSMS like below.
If you run into any issues while installing it, please share via comments.
Meanwhile, if you want to install SQL Server 2017 in just few minutes, here is the blog post which you should watch: Download and Install SQL SERVER 2017 Developer Edition for FREE. Remember SQL Server 2017 developer’s edition is FREE to use on development environment.
Reference : Pinal Dave (https://blog.sqlauthority.com)