July 16, 2009 at 3:50 am
Hi to all,
How i can backword to previous condition of my sql server 2005 after applying hotfixes..
I want to apply the new hot fixes on my SQL server 2005, how i can take the image of my server, b4 applying the hotfix.
Pleas help me out...
Thanks in advance.
Regards,
M.I.
________________________________________
M.I.
[font="Times New Roman"]
July 16, 2009 at 6:43 am
Hi,
It depends on what you really want to do, I was just having a look through the Microsoft support site and update I looked at had instructions on uninstalling, however this was a cumilitve update, not a single hot fix. So I would suggest reviewing the Microsoft link for the hotfix.
I beleive it is possible to rollback via a restore of you systm db's (master, model, msdb), however this would require a backup being done prior to the update.
Hope this helps.
July 17, 2009 at 12:29 am
Take full backup of user and system databases.
One nice feature that you have probably become accustomed to is the ability to uninstall programs, hot fixes and service packs by using the Add/Remove Programs feature of Windows. With SQL Server 2005 there is no easy way to uninstall the service packs. For both SQL Server 2005 SP1 and SP2, in order to get back to the previous version you need to do a complete reinstall of SQL Server 2005.
http://www.mssqltips.com/tip.asp?tip=1186
MJ
July 17, 2009 at 1:38 am
I think it really depends on what your updating, certain hot fixes can be uninstalled via the control panel;
see http://support.microsoft.com/kb/933097 for an example.
However as Manu rightly points out service packs prior to 3 (3 can be) can not be uninstalled directly, and will require a re-install of SQL.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply