Today we face space issue in C: drive and after deleting couple of files in User folder, I investigate further that below folders are consuming space good space.
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache
C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Update Cache
I my server we have SQL Server 2008 and 2012 installed, and curiously I investigated folders relevance to figure out if I can delete these
This folder holds all binaries to uninstall (cumulative update, critical update, or service pack) and accessed by control panel (Add remove programs).
Solution: In case you want to clear space by cleaning this folder (not advised by Microsoft), you can move this folder to another drive and create shortcut from Setup Bootstrap to that folder. Make sure shortcut name is also same” Update Cache”.
Don’t forget to give permission on folder in destination location “Update Cache”
FAQ:
Q1. When is “Setup Bootstrap\Update Cache” folder created and what is it used for?
Ans: When you install any SQL Server update (cumulative update, critical update, or service pack), the update installation media is cached in the SQL Server Update Cache folder. The entries in Add/Remove Programs are created from the contents of the cached media folder and are used to uninstall (as necessary) the most recent update that was applied to a particular component. The folder may contain multiple earlier updates, allowing for sequential removal of those updates if required.
A variation of this model occurs when a component was installed by a stand-alone MSI file instead of by SQL Server Setup. These components are serviced in-place by replacing the previous MSI file with the new one, without maintaining a history of previous versions. The original MSI file is required for both uninstall and repair operations.
Q2. When is “Setup Bootstrap\Update Cache” folder cleaned up or removed?
Ans: When all patches are removed from all instances, or when the product is uninstalled.
Q3. Why does the folder “Setup Bootstrap\Update Cache” continue to grow?
Ans: The folder grows with each update that's applied to your SQL Server instance. This growth occurs because each earlier version must be cached. This behaviour ensures that you can always access an earlier update if you need to.
Q4.What happens if you remove “Setup Bootstrap\Update Cache” folder or delete its contents?
Ans: If the Update Cache folder or some patches are removed from this folder, you can no longer uninstall an update to your SQL Server instance and then revert to an earlier update build. In that situation, Add/Remove Programs entries point to non-existing binaries, and therefore the uninstall process does not work. Therefore, Microsoft strongly encourages you to keep the folder and its contents intact.
I need the space though chief.
ReplyDelete