asked on We have SQL2014 12.0.2000. How Do I update it to SP2
how do you update SQL2014 to SP2?
Microsoft SQL Server
Last Comment
J.R. Sitman
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks I'll work on it tonight or tomorrow
Good luck. As stated do ensure you got a proper full current backup.
Last thing you want is an irreversible error. Once the DB Schema has been updated, removing a patch will not revert that process.
Hence backups of at least the Databases are critical (includes master db etc)
You can deploy only SP2 (first link) but best practice is to deploy the lot. They compliment and improve upon each-other.
Cumulative Update is highly recommended. These are released once every quarter from memory and not always available through Windows Update prior to SQL 2016.
Last thing you want is an irreversible error. Once the DB Schema has been updated, removing a patch will not revert that process.
Hence backups of at least the Databases are critical (includes master db etc)
You can deploy only SP2 (first link) but best practice is to deploy the lot. They compliment and improve upon each-other.
Cumulative Update is highly recommended. These are released once every quarter from memory and not always available through Windows Update prior to SQL 2016.
ASKER
Thanks