Sample code to restore the free WideWorldImporters Sample Database

Restore-WideWorldImporters-Full-Backup.sql

/* Download the WideWorldImporters sample database from Microsoft's GitHub page:
This file contains sample TSQL to restore the file WideWorldImporters-Full.bak

Notes & Warnings:
    This will BLOW AWAY any existing database named WideWorldImporters.
    Adjust the location of the backup file to the location you stored it on your test instance.
    This is suitable for dedicated test instances only.
*/
use master;
GO

/* If the database exists, kick everyone out */
IF DB_ID('WideWorldImporters') IS NOT NULL
BEGIN
    ALTER DATABASE WideWorldImporters SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
END
GO

/* Restore - and replace if it exists */
RESTORE DATABASE WideWorldImporters
    FROM DISK='S:\MSSQL\Backup\WideWorldImporters-Full.bak'
    WITH REPLACE,
    STATS=10;
GO