• How to Download and Restore Northwind database to SQL Server

How to Download and Restore Northwind database to SQL Server

  • 18K Views
  • Last Post 02 June 2023
jack posted this 24 December 2017

This tutorial shows you how to download Northwind database backup file (.bak) or (.sql) script, then restore the Northwind backup file to Microsoft SQL Server 2000/2005/2008/2012/2014/2016/2017/2019.

Northwind sample database that can be downloaded as an executable sql script or as a backup that can be restored with sample data currently works with SQL Server 2000 to 2019.

How do I download Northwind database?

To download the Northwind backup database file you can go Codeplex or Northwind database link, then unzip your downloaded file, you will see the Northwind.bak file or Northwind.sql script file.

How do I restore my Northwind database?

You need to login to your SQL Server, then right click on the database -> select Restore Database

restore northwind sql database

Next select your backup database file

restore northwind sql database

Next, You need to enter your database name that you want to restore

restore northwind sql database

Click OK button to finish

If your backup file is a script, you need to open the script file with SQL Server Management Studio, then press F5 to restore the database from the script.

sql northwind
  • Liked by
  • Aziz Lazreg
[email protected] posted this 02 June 2023

 

To download and restore the Northwind database to SQL Server, you can follow these steps:

  1. Download the Northwind database backup file:

  2. Install and open SQL Server Management Studio (SSMS):

  3. Connect to your SQL Server:

    • Open SSMS and connect to your SQL Server instance by entering the necessary credentials.
    •  

  4. Restore the Northwind database:

    • In SSMS, right-click on "Databases" in the Object Explorer panel and select "Restore Database..."
    • In the "General" tab, enter a name for the database, such as "Northwind".
    • In the "Source" section, select "Device" and click on the ellipsis button.
    • In the "Select backup devices" dialog, click on "Add" and navigate to the location where you downloaded the "Northwind.bak" file. Select the file and click "OK".
    • Back in the "Restore Database" dialog, ensure that the "To database" field is populated with the name you provided in step 4.
    • Click "OK" to start the restoration process.
Search
Popular Tags
This Weeks High Earners
Hot Topics
Close