0 Install SQL Server 2014 on Win2008R2

This post outline the basic steps for how to install SQL Server 2014 on Win2008R2.

Software

• SQL Server 2014 RTM
• Cumulate Update 3: SQL Server 2014 build versions http://support2.microsoft.com/kb/2936603
• Sample Database: http://msftdbprodsamples.codeplex.com/Releases/

http://technet.microsoft.com/en-us/library/ff803383.aspx 

Installation

I am going to manually apply the CTP later, hence I will not check the “use Microsoft update to check for updates”

I always prefer the Named instance.

Change the installation directory

Change the port number

Test Connectivity

s

Upgrade to CU3

At the time I write this post, the latest cumulative update is CU3.

http://support2.microsoft.com/kb/2936603 

Install Sample Database

The adventure Works 2014 is just the database backup. therefore we can easily to restore it with restore database statement.

http://msftdbprodsamples.codeplex.com/Releases/

Because I have change the default database directory for the sql server, therefore I need to use RESTORE FILELISTONLY to find the logical file name first and use WITH MOVE in the RESTORE DATABASE command.

RESTORE FILELISTONLY 

from disk='C:\Database\MSSQL12.SGC4SQL2014\MSSQL\Backup\AdventureWorks2014.bak'

Restore database AdventureWorks2014

from disk='C:\Database\MSSQL12.SGC4SQL2014\MSSQL\Backup\AdventureWorks2014.bak'

with replace, STATS =10, move 'AdventureWorks2014_Data' to 'C:\Database\MSSQL12.SGC4SQL2014\MSSQL\DATA\AdventureWorks2014_Data.mdf', 

move 'AdventureWorks2014_Log' to 'C:\Database\MSSQL12.SGC4SQL2014\MSSQL\DATA\AdventureWorks2014_Log.ldf'

Install Northwind sample database

The backup file can be download from http://northwinddatabase.codeplex.com/

RESTORE FILELISTONLY 

from disk='C:\Database\MSSQL12.SGC4SQL2014\MSSQL\Backup\NorthWind.bak'

GO

Restore database NorthWind

from disk='C:\Database\MSSQL12.SGC4SQL2014\MSSQL\Backup\NorthWind.bak'

with replace, STATS =10, move 'Northwind' to 'C:\Database\MSSQL12.SGC4SQL2014\MSSQL\DATA\NorthWind_Data.mdf', 

move 'Northwind_log' to 'C:\Database\MSSQL12.SGC4SQL2014\MSSQL\DATA\NorthWind_Log.ldf'

INSTALL AdventureWorksDW2014

restore database  AdventureWorksDW2014

from disk='C:\Database\MSSQL12.SGC4SQL2014\MSSQL\Backup\AdventureWorksDW2014.bak'

with move 'AdventureWorksDW2014_Data' to     'C:\Database\MSSQL12.SGC4SQL2014\MSSQL\DATA\AdventureWorksDW2014_Data.mdf'    ,  

move 'AdventureWorksDW2014_Log' to  'C:\Database\MSSQL12.SGC4SQL2014\MSSQL\DATA\AdventureWorksDW2014_Log.ldf',

replace,stats=10