October 31, 2009 at 9:21 am
need some help. i have installed SQL Sp3 and now i want to uninstall SQL Server SP3. so does any one have any idea how do i uninstall SQL Sp3. this is an urgent issue please help.
October 31, 2009 at 12:08 pm
Use add/remove program windows in the control panel.
October 31, 2009 at 12:21 pm
Lanny Irwan (10/31/2009)
Use add/remove program windows in the control panel.
You cannot uninstall only the SP3 for SQL Server 2005.
You have to unistall the entire Product (SQL Server Instance)
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 31, 2009 at 9:12 pm
Hi Guys,
I never done any service installation.
I want to know what are all the precautions do we need to take, before doing a service pack install??????
Also, what are common problems/errors when we install service packs?
How to handle such situations?
October 31, 2009 at 10:01 pm
Before Installing Service Pack on the Production / Staging Servers where Data is Crucial, Try installing on a test server and test the functionality of the applications / programs that depending on that Server (For this you may need to simulate / test redirect the application to the test Server)
In case of Installing in a clustered Environment, Installing SP3 will install only on the active Node.
Example if you have an Active / Active , and you perform installation on Node1, SP3 will be installed on the Instance that is active on Node1.
Once SP3 is Installed, as already mentioned in this forum thread, SQL has to be completely uninstalled to rollback the installation, so have a complete set of Backup of all the System and User Databases, Logins and Jobs etc.
There may be errors that may come up, look at the forums and other sites where the user experiences are posted regarding the same.
For step by step Installation instructions, look at the following site www.LearnSQLWithBru.com[/url] and under Blogs there is step by step instructions.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 31, 2009 at 10:12 pm
Hi Bru,
So, SP3 would have an impact if it is an clustered environment.
Here, in my environment there is no clusttered environment.
Can i do the SP3 install directly?
Just trying to understand is there any other implications!!!!
November 1, 2009 at 4:25 am
What issue did you encounter to validate the need to uninstall the sp ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
November 1, 2009 at 7:54 am
mahesh.vsp (10/31/2009)
Hi Bru,So, SP3 would have an impact if it is an clustered environment.
Here, in my environment there is no clusttered environment.
Can i do the SP3 install directly?
My Suggestion is No Don't Install SP3 Directly.
You should read the documentation about installing SP3 and then understand the impact and have everything backed up before installing (if incase you need to rollback.)
Installing SP3 has same impact on SQL Server on either a Standalone or a Clustered Envioronment.
There would some be additional steps and care needs to be taken in case of installing on a clustered environment, a point that I already mentioned.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 1, 2009 at 9:57 am
Bru has good advice. I would make sure you have good backups of all databases in case you need to need to rollback. That would be an uninstall of SQL Server and then a reinstall of SQL Server, then restoring the databases.
The other thing you need is time and a testing plan. Test the SP on another instance, and be sure your code still works and then re-run those tests on production after you have installed the SP. You need time to do this, so be sure your clients are aware of the downtime needed.
November 1, 2009 at 1:30 pm
Thank You. That was really useful!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply