After installing sample databases the second most asked question is WHERE IS NORTHWIND?
Northwind database was the best sample database for SQL Server 2000. Since I started to work with AdventureWorks of SQL Server 2005, I like AdventureWorks as much as Northwind. Northwind is not the best database due to few new features of analysis and reporting service of SQL Server 2005. MSDN Book On Line (BOL) uses the AdventureWorks in all of their examples and it makes it easy to follow up if a proper understanding of AdventureWorks schema is developed. However, SQL Server Compact Edition uses Northwind as a sample database.
If you still want to download and install Northwind and Pubs in SQL Server 2005, download them from here.
My recommendation: Start getting familiar with AdventureWorks.
UPDATE: SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2 explains how to restored NorthWind to SQL Server 2000 using images.
Reference : Pinal Dave (https://blog.sqlauthority.com)