Could you give me some advice on the best practice to update a SQL Server 2014 instance that is on version 12.00.2000.00? Can I install the Service Packs or do I need all of the cumulative updates as well?
Sql-server – Out-of-Date MS SQL Server 2014 instance
sql serversql server 2014
Related Question
- Sql-server – Maintaining SQL Server 2008 R2 on Windows 10
- Sql-server – Should I install SQL Server 2012 SP3 when I’m already running SQL Server 2014
- Sql-server – SQL Server Service Pack Questions
- Sql-server – SQL Server 2014 instance count
- Sql-server – Install of SQL Server 2014 SE
- Sql-server – Patching SQL Server 2014 Versus SQL Server 2014 Express
- Sql-server – Install last CU for SP2 without installing SP1 in sql server
Best Answer
Install the most recent service pack, then install the latest cumulative update.
According to SQL Server Builds, the most recent Service Pack for SQL Server 2014 is currently SP2.
CU10 is the most recent Cumulative Update.
Ensure you take a backup of your databases onto physically different media, and do this in a non-production environment to test the change prior to doing this to your production SQL Server.