This post is out of date. The download links and the steps below belong to an older version of SQL Server. I keep one current guide for both sample databases, and I update that one instead of this page.
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.
Still need to install these databases? Everything above is kept for the record. The steps that work today, the current download links and the errors people actually hit are all on one page, and that is the page I keep up to date.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
4 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
Install SQL Server 2016 or higher with SSMS 17.9 or higher and you will be fine.
Get an error:
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword ‘Full’.
Hi ! I just had instaled Standard Edition of SQL Server 20R 22 Developer Edition and SSMS :
when I try to install the Sample Database WideWorldImportersDW-Standard.bak
I replaced the script WideWorldImportersDW.bak to WideWorldImportersDW-Standard.bak, then
RESTORE DATABASE [WideWorldImportersDW]
FROM DISK = N’C:\WWI_DW\WideWorldImportersDW-Standard.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
Error message:
message. 3234, Level 16, state2, Line 3
The logical file ‘WWIDW_InMemory_Data_1’ does not part of the database ‘WideWorldImportersDW’. Use RESTORE FILELISTONLY to list the logical file names.
Mens. 3013, level16, state 1, Line 3
end anomaly RESTORE DATABASE.