Use microsoft updates

SQL Server Administration
1

Hey guys forgot to tick use Microsoft update while installing SQL server. Does it matter and if I wanna turn it on after installing how can I do that

2

That should not be a issue.
But,you should proactively look for service pack,security,Cumulative updates and apply them.

3

OK thanks that means I shouldn't be worried or loose sleep over it javeed
but also is there a way of turning it on after.

4

So Ahmad what do u think

5

No reason to turn it on after the fact - all that does is performs a check for an available updates during the installation. It does not setup SQL Server to use Windows Update to be automatically updated.

6

OK so it's not important, so all it does it gives you a list of updates to run like patches if there are any which I can get online anyway true?
the other question if I wanna add another instance will it ask me again and does it matter if I say no again

7

Your assistance is greatly appreciated thanks ahmad

8

It should ask you again - and no, it won't matter if you say no again. I always bypass that option - and perform the service pack and CU updates on my own.

9

OK thanks Ahmad, I'm doing a 2014 install and migrating dbs from 2008 do I need to run any updates or just ignore em for now and later apply cpu patches

10

Just wanted to know whether I have to run any updates after the install.
This use Microsoft updates just helps you find the latest SQL server updates and doesn't install anything for u, which is the same as getting list from the website.
As for the updates do we have to run them straight After the install or not necessarly

11

I would apply ALL Service Packs / Patches to any new install, before migrating any databases, so that any subsequent testing and operational use are all made with the latest patches.

See also this thread: Upgrading to SQL2012 / SQL2014

12

I'm just asking about use Microsoft update step in the install whether it does anything apart from just listing the updates if there's any

13

Seems like an unnecessary complication to me, I would want to make sure I had forced all MS SQL Service Packs and Patches at that point, and to do it in a time frame that suited my install process

But maybe Microsoft Update does a better job than i am giving it credit for ...

14

None of the migration documents or install says to apply patches after install, patches can be applied anytime on the database and they're not compulsary

15

All the mssql installation documents just mention the install steps, and my question earlier was about the use Microsoft update step, what it does, does it only list Nd only one guy Ahmad answered the question and said it only lists,

16

All that is true, but naive.

If there is a significant fix, and you don't apply it at the time of install, any testing / migration of databases you do will not have the benefit of the patch.

I can't understand why you would want to make an install WITHOUT the latest fixes and patches, you are leaving yourself wide open to bugs and security risks which have already been fixed in later patches

I think in reality that recent versions of SQL Server automatically apply all the latest patches at the time of INSTALL, but I'm not 100% sure of that and it does of course depend on internet connection being available and so on - so even if "included by default" its definitely not guaranteed and therefore worth double-checking.

If you don't want to install bug fixes at install time, before you start migrating your databases and using the system for critical work, that's up to you.

17

OK thanks for your opinion, but like I said all the install documents nonr of them mention applying service packs at the time of the iinstall and I think the 2014 SQL version already includes the latest patches in it.I was asking earlier first does the use Microsoft update install the patches or just list em. And secondly does 2014 software already include the patches

18

Can someone please provide feedback over what the Microsoft update I'm the install step Is and whether it does an install if the updates or it just lists the updates available

19

Is it possible to rerun the installation wizard just for the microsoft SQL server updates

20

Can somebody please confirm whether this step is needed, cos it's very confusing, cos it looks like it talks about the Microsoft windows update but you're saying it needs to be rub for SQL server updates