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 123»»»

step -by-step procedure for service pack upgradation?(on sql 2005 server) Expand / Collapse
Author
Message
Posted Sunday, July 12, 2009 12:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 8, 2012 5:25 PM
Points: 3, Visits: 61
Hi All,

Can you provide step -by-step procedure for service pack upgradation?(on sql 2005 server)
If possible,can u attach the screenshot for more clarifiction..

It will helps a lot for me:)

Please sahre your experiences on this event...

Waiting for help...


Post #751669
Posted Sunday, July 12, 2009 12:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 17, 2010 11:02 AM
Points: 347, Visits: 777
Is it clustered SQL Server or Stand alone SQL Server?

If it is Stand alone SQL Server, Installing Service Pack is pretty straight forward:

1.Down load and Read the read me file of the Service pack you want to install.
2.Backup all the databases, script the logins, jobs and save them in a safe location.
3.Do not stop any SQL services.Service pack installation will take care of that.
4.Start and follow the service pack install wizard steps.
5.At the end it will ask for a reboot. Because we did not stop any services at the start of the Installation.

Note: Before applying Service pack to a production server, Test it in a Test server, document the steps and apply for the development and QA servers and then finally apply for the production box


thanks
Post #751670
Posted Monday, July 13, 2009 7:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 2,036, Visits: 1,374
Also be aware that backing out a Service Pack pre-SQL Server 2008 is not a simple matter; you have to uninstall and reinstall SQL Server!

Regards
Lempster
Post #752005
Posted Monday, July 13, 2009 10:44 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:30 PM
Points: 33,055, Visits: 15,167
Just so we can discuss this with clear terminology. there is no such word as upgradation, and a service pack isn't an upgrade. It's an application of a patch to the server.

What level are you going from to what level on the server? Is this an RTM, base version of SQL Server 2005? What service pack are you applying?

The basic steps are listed above from rambill4. Download, read the instructions, and it's generally an install like any other sofware. Make sure you have backups, and time to reinstall SQL Server if there are issues.

You ought to have tested this on a test server, and WITH YOUR application to be sure that a change won't break anything.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #752226
Posted Tuesday, July 14, 2009 10:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 8, 2012 5:25 PM
Points: 3, Visits: 61
Hello All,

Thanks for your all replys..:)

my server is 2005 server enterprise edition(not cluster) and current sp is sp2.
Kindly sugget me in sp patching for this server.

Thanks in Advance
Post #753161
Posted Wednesday, July 15, 2009 3:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 2,036, Visits: 1,374
The replies you've been given so far plus the Release Notes for the Service Pack should be all you need to carry out a successful install of SP2. No one is going to post step-by-step instructions and/or screenshots - you need to do your own research.
Post #753264
Posted Wednesday, January 6, 2010 9:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 7, 2011 1:23 PM
Points: 67, Visits: 335
How is this installation of patches is different for cluster from a standalone.

Thanks
Ali
Post #842967
Posted Wednesday, January 6, 2010 10:02 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, March 14, 2014 3:15 PM
Points: 804, Visits: 935
Ali_SQLDBA (1/6/2010)
How is this installation of patches is different for cluster from a standalone.

Thanks
Ali


Major difference being the downtime associated with applying patches on a Standalone server.

Thanks..


The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Post #842983
Posted Wednesday, January 6, 2010 10:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 2,036, Visits: 1,374
Ali_SQLDBA (1/6/2010)
How is this installation of patches is different for cluster from a standalone.


There's not too much difference; Make sure you do the install from the Active node, the install wizard will detect that you have a clustered instance (or instances) and will prompt you to select the instance(s) to be patched. The install process will patch BOTH nodes (assuming a 2-node cluster) so you only need to do it once.
You'll need to reboot each node after the install.

The readme files for each Service Pack usually contain a section with specific instructions or points to note when installing on a Failover Clustered Instance.

Lempster
Post #842985
Posted Wednesday, January 6, 2010 10:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 7, 2011 1:23 PM
Points: 67, Visits: 335
My cluster is a AA cluster. So, I need to install on both nodes then. correct?
Post #843029
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse