Power by


Upgrade MS SQL 2014

** Myself
Pre-Step
-Install MS-SQL
-stop applicaton
run (from source path)
cd T:\sw_database\MSSQL_2014\51049461\x86-x64\EnterpriseEdition\X64
setup.exe /Action=Upgrade /UpdateSource="T:\sw_database\Patch MSSQL 2014"
upgrade
clip_image001
clip_image002

clip_image003

clip_image004
clip_image005
select instance
 clip_image007
 
clip_image009
 
clip_image010
 
clip_image011
 
clip_image012
 
clip_image013
Cancel
 

Update MSSQL08 SP2

# require 2008SP3 before upgrade 2014

"T:\sw_mig_upg\sw_database\Patch MSSQL 2008\SQLServer2008SP3-KB2546951-x64-ENU.exe"

done SP03

Re-Run Upgrade
cd T:\sw_database\MSSQL_2014\51049461\x86-x64\EnterpriseEdition\X64
 setup.exe /Action=Upgrade /UpdateSource="T:\sw_database\Patch MSSQL 2014"







  clip_image015





 
update rule






 
clip_image017







 
clip_image019









Upgrade



 
clip_image021





 
Done



restart server
Verity SQL Server 11.XX



 
clip_image022








 
verify application (Application =SAP)
clip_image023






Change the page verify option with the following commands:


SQL Server 2014 Management Studio.


use master


go


alter database PRD SET PAGE_VERIFY CHECKSUM;


go





use PRD


go


EXEC sp_updatestats


Go








enable xp_cmd



Use Master


GO





EXEC master.dbo.sp_configure 'show advanced options', 1


RECONFIGURE WITH OVERRIDE


GO





EXEC master.dbo.sp_configure 'xp_cmdshell', 1


RECONFIGURE WITH OVERRIDE


GO































0 comments:

Loading