Install and Attach Northwind Database in SQL Management Studio

In this post I will show How we can download, install NorthWind Database in our SQL Management Studio.

Install and Attach Northwind Database in SQL Management Studio steps :

Step 1 :

Download Northwind database MDF file using this link.

You can also get it from Official mircosoft website.

If you directly want the script file or BAK file,

1. download Northwind database script.
2. Northwind database BAK file

Step 2 : 

Open your SQL Management Studio and select Attach Database option from the menu of the connected server.

Attach Option will Pop-Up. In the Window select the .mdf file of your NorthWind databases files from the folders (Select the location at which you downloaded the MDF file for Northwind database):

C:\SQL Server 2000 Sample Databases

And Click Ok.

NorthWind Database will be attached and restored on your SQL Server. Expand the Databases node on your SQL Management Studio Server node :