Agent Jobs

How To Install SQL Server 2012 Express, SSMS, And Sample Databases

How to install SQL Server Express 2012, SQL Server Management Studio 2012, and add the 2012 Sample AdventureWorks Databases.
Go to the following link to get the software: https://www.microsoft.com/en-us/download/details.aspx?id=29062

Once you have those files you can move on to getting the Sample Databases by going here: https://sql2012kitdb.codeplex.com/

Download the .zip and extract the *.MDF files to the root of C:.

Proceed to install SQL Server Express 2012. Follow the prompts below. Note: Run all installations using ‘Run as Administrator’.

Review:
Install SQL Express 2012 – No License required.
Install SQL SSMS Client 2012 – No License required.
Install SQL Sample Database – Free databases supplied from Microsoft for learning purposes.
Basically; you install the Database Server, Database Client, and attach the sample database using the client.

To get the sample databases:
1. Copy the .MDF files under the root of C:.
2. Open the SQL Server Management Studio (as administrator), and run the following script.

USE MASTER;
SET NOCOUNT ON

CREATE DATABASE AdventureWorks2012
ON (FILENAME = 'C:AdventureWorks2012_Data.mdf')
FOR ATTACH_REBUILD_LOG ;

CREATE DATABASE AdventureWorksLT2012
ON (FILENAME = 'C:AdventureWorks2012_Data.mdf')
FOR ATTACH_REBUILD_LOG ;

CREATE DATABASE AdventureWorksDW2012
ON (FILENAME = 'C:AdventureWorksDW2012_Data.mdf')
FOR ATTACH_REBUILD_LOG ;

That’s it. :)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s