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

select instance

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"

 





 
update rule






 








 










Upgrade



 






 
Done



restart server
Verity SQL Server 11.XX



 









 
verify application (Application =SAP)







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