northwind database backup-Sql Server 2005 and 2008

Rating:        Based on 12 ratings
Reviewed:  11 reviews
Downloads: 486208
Released: Aug 11, 2011
Updated: Aug 12, 2011 by binoj7
Dev status: Alpha Help Icon

Recommended Download

example, 525K, uploaded Aug 12, 2011 - 381216 downloads

Other Available Downloads

Source Code
source code, 285K, uploaded Aug 12, 2011 - 104992 downloads

Release Notes - Northwind database backup for Sql Server 2005 and 2008.
Unzip / decompress the file then use the Restore Database option from Sql Server Management Studio 2005 / 2008 to restore the database - - Northwind database creation script for Sql Server 2005 and 2008.
Create a database called northwind in your Sql Server then.
Unzip / decompress the file then open the sql file in Sql Server Management Studio 2005 / 2008 and hit F5.
run the below command (sample)
sqlcmd -S Localhost -d Northwind -i D:\Sql\Northwind.sql

Reviews for this release

I had to reduce the rating because of the following: When you bring up the code in SSMS, the code is not color coded and there is some problem with the script (background text). When you run it will say there is no stored procedure 'U'. What I really did was to copy this into NotePad and save it with a different name. I called up the saved file in SSMS. Now it works. In SQL Server 2012 another ...
by mysorian on Oct 25, 2013 at 8:48 AM
Indented ERD:
by Arther5 on Mar 1 at 2:15 AM
This .bak file worked perfectly for me to restore the Northwind database into SQL 2014
by dougthomas99 on Nov 15, 2016 at 1:14 PM
Works on MSSQL 2008. Database restored with SSMS 2016, views and procedures working fine. Thanks for this perfect example!
by Sam_CodePlex_ on Nov 15, 2016 at 10:06 AM
Gostei da base de dados. Útil para estudo e ambiente de testes
by alexjosesilva on Dec 30, 2015 at 4:47 AM
Just Terrible - lazy route taken.
by Apollo013 on Oct 14, 2015 at 8:07 AM
I need demo database to demonstrate reading record with children. Northwind database is just what I was looking for.
by gbukauskas on Jun 21, 2015 at 3:04 AM
Worked for me on SQL 2014. Thanks!
by datawizard on Mar 27, 2015 at 5:26 PM
The ERD (database table relationship) picture is AWFUL (and the download is worse)! Any half-decent Dev/DBA would avoid crossing lines and base those FK lines on specific columns. Ain't you got no pride man? If you want a proper ERD layout see my pic on gdrive at
by DickInKent on Mar 4, 2015 at 7:57 PM
I could not get the backup version to work so I, too, went to the scripted version. Just to clarify: what the couple other reviewers ran into was an encoding problem. The file is UTF16 and both SSMS and sqlcmd balk at that; you have to convert the file to ASCII. The simplest way to do that is with PowerShell: PS> gc .\northwind.sql -Encoding Unicode | sc northwind2.sql
by msorens on Aug 13, 2014 at 9:38 PM
I agree with @mysorian (from 2013-Oct-25), I had to create the Northwind DB (Create Database Northwind) command...and edit the SQL code in a Text Editor...and save it then copy it inside the SQL Server Mgr . reason: the code was changed as Spaced characters. eg. if "USE Northwind"? then it changed it to "U S E N o r t h w i n d" !!!
by CoderKim0212 on May 30, 2014 at 4:29 AM