SQL Server 2008 SP2 / SQL Server 2005 SP4 upgrade
Hello,
I need to install 2008 SP2 and 2005 SP4 on the production servers. I had experienced issues when doing these SP's before due to missing msi and msp files (deleted by windows admins due to low disk space issues) but in non-prod environments. Since I am going to work on prod, I would like to find out if there are any missing msi or msp files before starting the upgrades, is there any way I can find that? Your inputs are truly appreciated.
Regards,
Rocky
I need to install 2008 SP2 and 2005 SP4 on the production servers. I had experienced issues when doing these SP's before due to missing msi and msp files (deleted by windows admins due to low disk space issues) but in non-prod environments. Since I am going to work on prod, I would like to find out if there are any missing msi or msp files before starting the upgrades, is there any way I can find that? Your inputs are truly appreciated.
Regards,
Rocky
LuckyDuck
The smart move would be to virtualize your production servers and test the upgrade. This is a procedure that I perform on a regular basis. VMWare ESXi server is a "free" product. You can take some existing machine you have and create the server and then manage it from a workstation. Once virtualized you can check on any number of scenarios before committing changes on your production server. Using ESXi is pretty straight forward and shouldn't take you too long to learn to do the testing. This is really the only way that you are going to know that your upgrades and changes are going to work on your production boxes. The cost is nothing for ESXi, having some extra hardware around shouldn't be too much of a burden if you don't have it now.
http://www.microsoft.com/download/en/details.aspx?id=184
http://www.microsoft.com/download/en/details.aspx?id=184
Download the required SP's from the related sites. Install them in dev box. Monitor it for couple of days.
At the time of installation only you can able to know whether is there any thing missing (msi) files like that, so that you can able to use the same SP for live also.
--Venkat
http://www.microsoft.com/download/en/details.aspx?id=184
Download the required SP's from the related sites. Install them in dev box. Monitor it for couple of days.
At the time of installation only you can able to know whether is there any thing missing (msi) files like that, so that you can able to use the same SP for live also.
--Venkat
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Using the link below, I was able to find all the missing msi and msp files before starting the install
http://support.microsoft.com/kb/969052
http://support.microsoft.com/kb/969052