Saturday, September 27, 2014

0 Install SQL Server 2014 on Win2008R2

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

Software

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

image_thumb1

Installation

image

image

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

image

image

image

I always prefer the Named instance.

image

image

image

Change the installation directory

image

image

image

image

image

image

Change the port number

image

Test Connectivity

images

Upgrade to CU3

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

image

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

image

image

image

image

image

image

image

Install Sample Database

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

image

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'

image

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'

image

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

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates