SQL SERVER – How to Install New Sample Database WideWorldImportersDW.bak

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.

SQL SERVER - How to Install New Sample Database WideWorldImportersDW.bak WWI-DW-01

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)

, , , , ,
Previous Post
Download and Install SQL SERVER 2017 Developer Edition for FREE
Next Post
SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint

Related Posts

2 Comments. Leave new

  • I have installed sql server 2012 in my laptop. In addition, I have recently installed ssms 2016. I’ve noticed that I can get access to my instance from 2012 when logging. When I try to download the wideworldImporters sample db either full or standard I get this error :

    Msg 3241, Level 16, State 0, Line 1
    The media family on device ‘C:\WideWorldImporters-Full\WideWorldImporters-Standard.bak’ is incorrectly formed. SQL Server cannot process this media family.
    Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.

    Thanks in advance for any help

    Reply

Leave a Reply

Menu