Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Update the SQL patch Expand / Collapse
Author
Message
Posted Tuesday, February 9, 2010 7:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 29, 2010 8:57 PM
Points: 15, Visits: 49

Hi,

IS there any process of applying SQL patch in SQL Production Server. For a instance , 3 years old production database I need to update the new patch. Can you explain ?
Post #862429
Posted Tuesday, February 9, 2010 7:52 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:00 PM
Points: 979, Visits: 3,364
How can you have a SQL 2008 database that is 3 years old? Uhmmmmm, SQL 2008 came out in...well, 2008 and it is only 2010, that is only 2 years.

Andrew SQLDBA
Post #862442
Posted Tuesday, February 9, 2010 7:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:21 AM
Points: 6,743, Visits: 8,517
- Read the according KB ref for the hotfix !!

- Test it on a DBA test server to prepare yourself for the production rollout (timing, expected problems,..)

- Is this a service pack or are you actually talking of a single hotfix ?
(If you have the option, go for the service pack, because we expect that to be better tested)

- As always, play it safe and start with a Full database backup of all databases of your instance ! (including the resource database (sql2005/2008))


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #862445
Posted Tuesday, February 9, 2010 7:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 29, 2010 8:57 PM
Points: 15, Visits: 49
thanks for the reply.

can you tell about single hotfix and service pack ?
Post #862448
Posted Tuesday, February 9, 2010 8:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:21 AM
Points: 6,743, Visits: 8,517
And there are off course "cumulative hotfixes" = a set of hotfixes, but not as tested a you would expect for a service pack

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #862456
Posted Wednesday, February 10, 2010 4:49 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 17,967, Visits: 15,979
Same rules apply to service packs. Service packs will list the hotfixes involved in the SP. Read the kb's - test in dev and then promote through your environments if testing is satisfactory.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #863726
Posted Tuesday, February 16, 2010 3:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
I thing Service Pack = Many Hotfixes. Is there any good article that describes as how to apply the service pack or hotfixes?
Post #865943
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse