Post reply

Step by step to install Cumulative update in sql 2008 r2

  • September 9, 2014 at 10:03 pm

    #311480

    Hi all ,

    Anyone here know the step by step to install Cumulative update in sql 2008 r2?

    Pls advise !!

    Thank you

    Cheers

  • September 10, 2014 at 2:33 am

    #1744346

    The installation of a CU is basically the same as the installation of a SP. Of course: to be sure and on the safe side you should first execute a CU upgrade on a non-production server!!

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • September 10, 2014 at 5:48 pm

    #1744617

    HanShi (9/10/2014)

    The installation of a CU is basically the same as the installation of a SP. Of course: to be sure and on the safe side you should first execute a CU upgrade on a non-production server!!

    Thank you for the response and sorry for the double post .

    Hmm should I stop all sql services before I install CU ?

    Pls advice

  • September 11, 2014 at 1:10 pm

    #1744903

    I haven't installed a CU recently, but if I recall correctly all SQL services need to be stopped. During the initial configuration steps a check on locked files is performed, before the actual install is started.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • September 14, 2014 at 7:26 pm

    #1745345

    HanShi (9/11/2014)

    I haven't installed a CU recently, but if I recall correctly all SQL services need to be stopped. During the initial configuration steps a check on locked files is performed, before the actual install is started.

    OK . Thank you !

    Then finally , Should we restart the computer or the Restart the SQL Server ?

  • September 15, 2014 at 5:27 am

    #1745430

    If you have stopped the SQL Server services during install and no locked files were found, you only have to start the SQL service again. If you were not able to stop all services/processes that were locking files (and thus you kept seeing locked files in the list) a reboot of the server may be required.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply