SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters

Few days back I wrote blog about SQL Server 2016 Developer Edition free download. If you didn’t get a chance to have a look, here is the link. Download SQL SERVER 2016 Developer Version for FREE. Let us learn about how to install Sample Database WideWorldImports.

In that blog, I also said that, here is a new sample database called WideWorldImporters. This database is a replacement of old sample database called AdventureWorks (Engine version) and AdventureWorksDW (Data Warehouse version)

SQL SERVER 2016 - How to Import New Sample Database WideWorldImporters WideWorldImporters-800x259

Here is the link to download latest version of the sample database Wide World Importers sample database v1.0

Once you go to the page, you would find various files to download. Here is the quick list about few of them which you would be using.

File NamePurpose
WideWorldImporters-Full.bakUse this if you have Enterprise/Developer/Enterprise Evaluation Edition
WideWorldImporters-Standard.bakUse this if you have Standard Edition
WideWorldImportersDW-Full.bakUse this if you have Enterprise/Developer/Enterprise Evaluation Edition
WideWorldImportersDW-Standard.bakUse this if you have Standard Edition

The reason there are two for the standard edition separately is because there are many features which are not available in standard edition. If you try to “full” on the standard edition, you will not be able to open the database.

Here is the command which you can use to restore the database. Note that I have created a folder called C:\WideWorldImporters-Full. I have kept a backup. Please change based on your server configuration.

Install Sample Database WideWorldImports

USE [master]
RESTORE DATABASE [WideWorldImporters] FROM  
DISK = N'C:\WideWorldImporters-Full\WideWorldImporters-Full.bak' WITH
MOVE N'WWI_Primary' TO N'C:\WideWorldImporters-Full\WideWorldImporters.mdf',  
MOVE N'WWI_UserData' TO N'C:\WideWorldImporters-Full\WideWorldImporters_UserData.ndf',  
MOVE N'WWI_Log' TO N'C:\WideWorldImporters-Full\WideWorldImporters.ldf',  
MOVE N'WWI_InMemory_Data_1' 
TO N'C:\WideWorldImporters-Full\WideWorldImporters_InMemory_Data_1'
GO

Once restore is done, this is what you should see

SQL SERVER 2016 - How to Import New Sample Database WideWorldImporters WWI-01

Do you see a table with clock icon? What is that feature called? These are great ways of learning the new capabilities via the sample database.

Here is a quick SQL in Sixty Seconds video where I explain how we can install sample database.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Restore, SQL Sample Database, SQL Scripts, SQL Server, WideWorldImporters
Previous Post
SQL SERVER – Unable to Start SQL Agent – SQL Server Agent Terminated (Normally)
Next Post
SQL SERVER – Installation Error – The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive.

Related Posts

12 Comments. Leave new

  • Greetings Pinal, the link leads to generic samples download page. The following link would be more accurate.
    https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases

    Have a great day ahead!

    Reply
  • Sakaravarthi j
    June 17, 2016 11:41 am

    The clock icon table object is temporal table. it is a new feature in SQL 2016. this table maintains history of the data changed/ updated.

    Reply
  • Hi Pinal,

    I downloaded the WideWorldImporters-Full.bak and restored. But I am not able see many features that are present in SQL server 2016.
    Example: I couldn’t see that clock symbols for those tables,
    I couldn’t see Stretch option in tasks,
    Also I couldn’t see Always Encrypted folder under the security folder in the WideWorldImporters database.

    I am using SQL server 2014 management studio and connected to the SQL server 2016 instance, Is this the problem.

    Reply
  • Reply
  • I was able to fix this….Management studio 2014 was the problem. After installing 2016 Management studio I am able to see all the features available in SQL Server 2016

    Reply
  • This script gives me an error.

    USE [master]
    RESTORE DATABASE [WideWorldImporters] FROM
    DISK = N’C:\Data\WideWorldImporters-Full.bak’ WITH
    MOVE N’WWI_Primary’ TO N’C:\Data\WideWorldImporters.mdf’,
    MOVE N’WWI_UserData’ TO N’C:\Data\WideWorldImporters_UserData.ndf’,
    MOVE N’WWI_Log’ TO N’C:\Data\WideWorldImporters.ldf’,
    MOVE N’WWI_InMemory_Data_1′
    TO N’C:\Data\WideWorldImporters_InMemory_Data_1′
    GO

    Msg 5120, Level 16, State 108, Line 2
    Unable to open the physical file “C:\Data\WideWorldImporters_InMemory_Data_1”. Operating system error 0: “(null)”.
    Msg 3013, Level 16, State 1, Line 2
    RESTORE DATABASE is terminating abnormally.

    It does create the other MDF, NDF and LDF items.

    Thanks for your help.

    Reply
  • I keep getting this error message on our SQL 2016 Developer Edition.

    (4 row(s) affected)
    10 percent processed.
    20 percent processed.
    30 percent processed.
    Processed 1464 pages for database ‘WideWorldImporters’, file ‘WWI_Primary’ on file 1.
    Processed 53096 pages for database ‘WideWorldImporters’, file ‘WWI_UserData’ on file 1.
    Processed 33 pages for database ‘WideWorldImporters’, file ‘WWI_Log’ on file 1.
    Processed 3862 pages for database ‘WideWorldImporters’, file ‘WWI_InMemory_Data_1’ on file 1.
    Msg 41316, Level 16, State 0, Line 0
    Restore operation failed for database ‘WideWorldImporters’ with internal error code ‘0x82000006’.
    Msg 3167, Level 16, State 1, Line 7
    RESTORE could not start database ‘WideWorldImporters’.
    Msg 3013, Level 16, State 1, Line 7
    RESTORE DATABASE is terminating abnormally.
    Msg 3414, Level 21, State 1, Line 7
    An error occurred during recovery, preventing the database ‘WideWorldImporters’ (11:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

    This will install on another SQL 2016 Developer Edition just not this one. Have you run across this before and if so do you know what would cause this?

    Reply
  • I am getting this error: The database was backed up on a server running version 13.00.1601. That version is incompatible with this server, which is running version 12.00.2000″ Any suggestions how to update server to 13.00 /fix the error?

    Reply
    • The backup which you have is taken from SQL Server 2016 and we can’t restore it on lower version. 12.00.xxxx is SQL Server 2014. So you need to upgrade SQL engine to SQL Server 2016 which would be 13.00.xxxx

      Reply
  • I’m on sql server 2016 Enterprise Edition Sp1. restore is failing with error:

    5 percent processed.
    10 percent processed.
    15 percent processed.
    20 percent processed.
    25 percent processed.
    30 percent processed.
    Processed 1464 pages for database ‘WideWorldImporters’, file ‘WWI_Primary’ on file 1.
    Processed 53096 pages for database ‘WideWorldImporters’, file ‘WWI_UserData’ on file 1.
    Processed 33 pages for database ‘WideWorldImporters’, file ‘WWI_Log’ on file 1.
    Processed 3862 pages for database ‘WideWorldImporters’, file ‘WWI_InMemory_Data_1’ on file 1.
    Msg 41316, Level 16, State 0, Line 4
    Restore operation failed for database ‘WideWorldImporters’ with internal error code ‘0x82000009’.
    Msg 3167, Level 16, State 1, Line 6
    RESTORE could not start database ‘WideWorldImporters’.
    Msg 3013, Level 16, State 1, Line 6
    RESTORE DATABASE is terminating abnormally.
    Msg 3414, Level 21, State 1, Line 6
    An error occurred during recovery, preventing the database ‘WideWorldImporters’ (10:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

    Reply

Leave a Reply