Uninstall of SQL Server 2008 SP3 failed - partially?
Due to a vendor not supporting their product (yet) on SQL Server 2008 SP3, I tried to uninstall SP3 and revert back to SP2 and received the following error messages:
"The feature you are trying to use is on a CD-ROM or other removable disk that is not available. Insert the 'Microsoft SQL Server 2008 BI Development Studio' disk and click OK.
The path 'Please insert next disk' cannot be found. Verify that you have access to this location and try again, or try to find the installation package
'sql_bids.msi' in a folder from which you can install the product Microsoft SQL Server 2008 BI Development Studio.
Error log is in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120121_210
Afterwards, the version number on the instance (viewed using SQL Server Management Studio) indicates SP2 (10.0.4064) but I am concerned that the installation has parts at SP2 and others still at SP3 - a situation that may cause future problems on this production database server.
What is the best way to correct this situation, other than a full-uninstall/reinstall of SQL Server?
"The feature you are trying to use is on a CD-ROM or other removable disk that is not available. Insert the 'Microsoft SQL Server 2008 BI Development Studio' disk and click OK.
The path 'Please insert next disk' cannot be found. Verify that you have access to this location and try again, or try to find the installation package
'sql_bids.msi' in a folder from which you can install the product Microsoft SQL Server 2008 BI Development Studio.
Error log is in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120121_210
Afterwards, the version number on the instance (viewed using SQL Server Management Studio) indicates SP2 (10.0.4064) but I am concerned that the installation has parts at SP2 and others still at SP3 - a situation that may cause future problems on this production database server.
What is the best way to correct this situation, other than a full-uninstall/reinstall of SQL Server?
ASKER
dtodd -
Thank you for your very fast reply. Unfortunately we don't have a lot of physical media - almost everything is downloaded. Servers are patched via SCCM and SP3 was provided this way as well.
I also do not know where this file is: is it within SP2 somewhere or the base SQL Server 2008 installation?
Any additional help would be appreciated. Thank you.
Thank you for your very fast reply. Unfortunately we don't have a lot of physical media - almost everything is downloaded. Servers are patched via SCCM and SP3 was provided this way as well.
I also do not know where this file is: is it within SP2 somewhere or the base SQL Server 2008 installation?
Any additional help would be appreciated. Thank you.
Hi,
I'd download the media (again) and burn it to disk again, and try that.
While you could get 3rd party progs to mount the ios, I'd prefer to see the ios burn to media.
Regards
David
I'd download the media (again) and burn it to disk again, and try that.
While you could get 3rd party progs to mount the ios, I'd prefer to see the ios burn to media.
Regards
David
ASKER
dtodd -
That sounds like a good idea. Any idea if I just need to download (and burn to disk) SP2 or should I have the full base install product available as well?
Additionally, since the currently reported version of the database installation is 10.0.4064 and the "base" SP2 version number is 10.0.4000, I assume that if I reinstall SP2 after all of this that I will also need to reinstall any patches released for SP2 afterwards, correct?
Thank you.
Steve
That sounds like a good idea. Any idea if I just need to download (and burn to disk) SP2 or should I have the full base install product available as well?
Additionally, since the currently reported version of the database installation is 10.0.4064 and the "base" SP2 version number is 10.0.4000, I assume that if I reinstall SP2 after all of this that I will also need to reinstall any patches released for SP2 afterwards, correct?
Thank you.
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
dtodd -
Thank you. I will go ahead and try this, specifically:
I greatly appreciate your help.
As this is the first question I have ever posted to EE, is the expected behavior to award points at this time or after I actually perform the recommended steps and confirm the result is what is needed?
Steve
Thank you. I will go ahead and try this, specifically:
Downloading the equivalent of both the base product and SP2
Retrying to uninstall SP3
Reinstalling SP2 (just to make sure everything is on the same "level"
Installing any other patches/CUs that are supported by the vendor.
I greatly appreciate your help.
As this is the first question I have ever posted to EE, is the expected behavior to award points at this time or after I actually perform the recommended steps and confirm the result is what is needed?
Steve
Hi Steve,
>> As this is the first question I have ever posted to EE, is the expected behavior to award points at this time or after I actually perform the recommended steps and confirm the result is what is needed?
Standard SQL Answer - it depends.
If the above is going to take the next three weeks to do and confirm, then award points now.
Since in this case I figure you will have succeeded in the the next day or two then leave this open for a couple more days and see how you get on.
Regards
David
>> As this is the first question I have ever posted to EE, is the expected behavior to award points at this time or after I actually perform the recommended steps and confirm the result is what is needed?
Standard SQL Answer - it depends.
If the above is going to take the next three weeks to do and confirm, then award points now.
Since in this case I figure you will have succeeded in the the next day or two then leave this open for a couple more days and see how you get on.
Regards
David
ASKER
David,
OK - will do. Thank you. As I have to do this on a production server, I won't be able to try it until the weekend, but I will update this with the status as soon as I can afterwards.
Steve
OK - will do. Thank you. As I have to do this on a production server, I won't be able to try it until the weekend, but I will update this with the status as soon as I can afterwards.
Steve
ASKER
Second attempt at uninstalling SQL Server 2008 SP3 seems to have worked. Went to reinstall SP2 and it reported there was nothing to update. So, I am considering this fixed and solved.
Thank you, David.
Steve
Thank you, David.
Steve
Why can't you just insert the CD-Rom/DVD as the error message is requesting?
Once finished uninstalling sp3, suggest re-applying sp2 - to be sure to be sure to be sure ...
HTH
David