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.