4

I have to install the KB4019090 on my SQL Server 2012.

My SharePoint 2013 farm with MS Project 2013 depends of it.

What are the best practice to follow to make sure my farm will be up and running after the update?

Thanks a lot !

Regards,

  • 1
    KB4019090 deals with analysis services component of sql server. Do you have that functionality required in your application? As far as I know, there is no direct linkage/dependency b/ween KB4019090 and MS Project 2013 . But as a general practice you can install the same , KB4019090 in your dev.env and test any features of MS PROJECT 2013 are getting affected or not. If not , you can confidently install the KB4019090 on your PROD. Env. – SaMolPP Aug 28 '17 at 9:12
  • to be honest, I'm not managing the app themselves, only the core part of Project as I don't know this product :( I was more looking for a procedure/best practice procedure with steps to follow before the DBA deploys this update on the SQL server. – Said Aug 28 '17 at 9:23
5

I have installed tons of SQL-Server Updates on lots of SharePoint farms. SharePoint never got broken.

But if you heavily rely on that environment, you should have a testing-environment that matches prod environment as close as possible. You can install updates there and check if everything works as expected. Checklists are very helpful to standardize this process. You should also get your application-owners involved to help you building those checklists!

I would recommend to install Cumulative Update 10 for SQL-Server 2012 ServicePack 3 (KB4025925) instead of KB4019090. The hotfix is contained in the CU. CUs are tested way more intensive by Microsoft than a hotfix.

The process of installing the update is very straightforward:

  • Make sure you have a working full backup!
  • Shut down your SharePoint-Server. This makes sure every database-connection is closed. Just stopping IIS will still keep lots of connections open.
  • Install the Update on SQL-Server. If necessary, restart the Server
  • Make sure SQL Server works as expected (e.g. by connecting via SQL Server Management Studio)
  • Start SharePoint and check if everything works as expected.
  • thanks for your input. Should I switch off all of them (WFE + Apps + OWA ) ? Thanks a lot :) – Said Aug 28 '17 at 9:36
  • 1
    WFE + App: Yes. OWA does not open any database connection, so it can stay online during the patching process. – MHeld Aug 28 '17 at 9:38
  • 1
    I would also take the full backup of databases before applying patches. and full backup after updates. – Waqas Sarwar MVP Aug 28 '17 at 12:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.