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
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
0 comments:
Post a Comment