Sample Header Ad - 728x90

Sql Server 2014 update path advice

0 votes
1 answer
316 views
I recently inherited a SQL Server 2014 installation and I'd like to install updates. The virtual machine runs Windows Server 2016 standard. The server has about 50+ databases with 400Gb of data. I'm a developer and don't have much DBA knowledge. Current plan is to update SQL Server to 2014 SP3 (right now it's RTM). Are there any problems I should be aware of? I do plan on trying it out on a non-production server first - but unfortunately can't get the same exact Windows version. Is there some script or utility to healthcheck SQL Server installation? I doubt that manually running sql statements will be very thorough. I only found Brent Ozar's blitz so far.
Asked by chester89 (127 rep)
Mar 30, 2020, 09:24 AM
Last activity: Mar 30, 2020, 07:57 PM