Today a colleague and me bumped into an issue where we had to remove a SQL Server instance from a SQL Server which ran multiple SQL Server instances. Of course, there are TechNet/MSDN articles about just that but still we were cautious since while following the instructions, we soon bumped into this screen: So we […]
Category: SQL
SharePoint Config database Log file too big
If your SharePoint Config Database is Very Large in size. C:\Windows\SYSMSI The area of this folder which contained all the data was C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data This folder contained many SQL databases and log files, and after some research I discovered that my largest files were Transactional Log files for Sharepoint. The biggest of these files was SharePoint_Config_ffffffff-ffff-ffff-ffff-fffffffffffffffffff_log.LDF and was […]