Is it "safe" to delete any of the subfolders in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\ from my drive to free up space?
Or is it needed for upgrade/uninstall and other patches? Right now the Update Cache folder contains KB968369 (sp1) which takes up 416mb, which seems like a candidate for freeing up space.
According to this site, you shouldn't. You can compress it and remove log files, but you shouldn't delete it.
If I hadn't googled for it I would probably have tried searching to see if any of the files were open, and if not, then copied them to a new location for storage until I was certain the server worked well without it, and if there was an issue recopy them over.
Then again I also have been known to delete the hidden/compressed update files in the Windows directory which is also considered bad practice from what some have said and have had no horrible side effects while freeing up hundreds of meg in space.
An alternative would be to look into installing larger drives and expanding your disk partitions. Depending on the role of the server this could be a major project, though, but in the end if you're in need of freeing space on a database server it's probably time to look at upgrading that subsystem, at least.
don't delete it. Mine is 2.1 GB :'(
Questions and answers regarding SQL Server installation best practices, the files we can delete after a service pack is installed, user rights and how many instances are necessary for different application. 1. After you installed a Service Pack for SQL Server 2008 R2, is it possible to delete part of the files without altering the functioning of SQL Server? If yes, what files?
The files that are added during the installation of a Service Pack are absolutely necessary for the SQL Server instance (for which you installed the service pack) to function properly: http://msdn.microsoft.com/en-us/library/dd638062(v=SQL.105).aspx
”The recommended disk space requirements are approximately 2.5 times the size of the package to install, download, and extract the package. After installing a service pack, you can remove the downloaded package. Any temporary files are removed automatically.”
So the files that are added or modified during the installation of the Service Pack are absolutely necessary and is not indicated to delete them once the installation is finished.
The folder « C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache » is used to verify what are the service packs or cumulative updates already installed and it is also not indicated to delete it. Normally, as the article mentioned above explains, after the service pack is installed he will delete the temporary files he created and that are no longer necessary.
The only thing that can be deleted after the service pack is installed is the installation kit that was used to install the service pack.
An alternative solution if you're low on disk space, would be to move the contents to a new directory on a different drive/partition, then use mklink /j to create a junction. More info on junctions can be found here https://msdn.microsoft.com/en-us/library/windows/desktop/aa365006(v=vs.85).aspx
From Microsoft site:
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 think, it depends totally on your situation. I have two SQL Server Express instances running currently for development. One is 2012 instance which is old, as I will not remove patches installed long ago and probably no new patches will be available, I will remove files from this directory. If problems occur for future updates uninstall and install again will be pussible, I guess.
don't remove it:
Summary
The Update Cache folder for Microsoft SQL Server is found in the following location:
C:\Program Files\Microsoft SQL Server\\Setup Bootstrap\Update Cache
This article provides information to help you understand why this folder is created and what it's used for. More Information
When is this folder created and what is it used for?
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.
When is this folder cleaned up or removed?
When all patches are removed from all instances, or when the product is uninstalled.
Why does the folder continue to grow in size?
The folder grows in size with each update that's applied to your SQL Server instance. This growth occurs because each earlier version must be cached. This behavior ensures that you can always access an earlier update if you need to.
What happens if you remove this folder or delete its contents?
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.