deleting *.cache files from SQL Server

Cache files are generated when Data collection is enabled and Collection set is running.

You can delete the files if not required after disabling the Data Collector.

USE msdb;
GO
EXEC dbo.sp_syscollector_disable_collector;

To enabled Data Collector

USE msdb;
GO
EXEC dbo.sp_syscollector_enable_collector ;

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *