Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 what are the steps follow for Patches apply in sql

Author  Topic 

sql2020
Yak Posting Veteran

54 Posts

Posted - 2010-08-23 : 05:43:03
what are the steps follow for Patches apply in sql? pls explain?

sql2020

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-23 : 08:44:20
if you download the patch or cumulative fix, there will be a manual or read me file included, follow the instructions there

--------------------
keeping it simple...
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-23 : 10:31:04
make sure you have good backups.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-23 : 11:14:07
What version of SQL Server are you using? It makes a difference as the procedure is different for 2008.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 2010-08-24 : 12:21:04
Everyone has said what I wanted on patches, so I'll talk about Service packs - do not install one until it's first hotfix comes out.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-24 : 12:25:53
quote:
Originally posted by Jake Shelton

Everyone has said what I wanted on patches, so I'll talk about Service packs - do not install one until it's first hotfix comes out.



That is not true. In fact, it's discouraged unless there is a critical security vulnerability or unless you are encountering one of the bugs fixed in a hotfix.

This is especially not true of 2005+.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 2010-08-24 : 12:48:41
quote:
Originally posted by tkizer

quote:
Originally posted by Jake Shelton

Everyone has said what I wanted on patches, so I'll talk about Service packs - do not install one until it's first hotfix comes out.



That is not true. In fact, it's discouraged unless there is a critical security vulnerability or unless you are encountering one of the bugs fixed in a hotfix.

This is especially not true of 2005+.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Fair enough, I wasn't/am not aware of the security issues you speak of, though differing environments do seem to have radically divergent approaches to the timing of pack application.
Go to Top of Page
   

- Advertisement -