Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


step -by-step procedure for service pack upgradation?(on sql 2005 server)


step -by-step procedure for service pack upgradation?(on sql 2005 server)

Author
Message
MNR
MNR
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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 meSmile

Please sahre your experiences on this event...

Waiting for help...
rambilla4
rambilla4
Old Hand
Old Hand (351 reputation)Old Hand (351 reputation)Old Hand (351 reputation)Old Hand (351 reputation)Old Hand (351 reputation)Old Hand (351 reputation)Old Hand (351 reputation)Old Hand (351 reputation)

Group: General Forum Members
Points: 351 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
Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
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
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36070 Visits: 18736
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
My Blog: www.voiceofthedba.com
MNR
MNR
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 61
Hello All,

Thanks for your all replys..Smile

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:-)
Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
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.
ALI SQLDBA
ALI SQLDBA
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 335
How is this installation of patches is different for cluster from a standalone.

Thanks
Ali
The_SQL_DBA
The_SQL_DBA
SSC Eights!
SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)

Group: General Forum Members
Points: 808 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."
Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
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
ALI SQLDBA
ALI SQLDBA
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 335
My cluster is a AA cluster. So, I need to install on both nodes then. correct?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search