Typical ways for dealing with LDF files that take up a lot of space, recommend these processes to shrink/ eliminate the drive space being occupied.
http://www.sharepointboris.net/2008/10/sharepoint-config-database-log-file-too-big-reduce-it/ and http://geekswithblogs.net/RogueCoder/archive/2008/06/03/122588.aspx
As an example of following these steps for SBS Monitoring
database visible in Microsoft SQL Server Management Studio Express GUI whose path location on disk is: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
(this path not shown in screenshot)
I followed these commands on the GUI:
DB: SBSMonitoring > Tasks > Delete > Log files
and gain about 1-2 GB space.
One the other hand, I find the Sharepoint related DB files under path (shown in screenshot):
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
But, this database is not visible in Microsoft SQL Server Management Studio Express GUI.
I've looked at several answers and tutorials on how to clear out the LDF via GUI and SQL commands, but that is assuming the DB is visible.
What steps can I take to properly clear out the LDF log files for this DB?
Do I have to first add/ connect to it via the SQL GUI? Or clear out without adding via SQL commands? Or clear it out with simple file delete in explorer {not recommended from what I read most places}?
This is what I'm reading so far, but haven't found a way to add/ access that DB via those Files and then use above mentioned steps & guides.
Screenshot of files, location & DBs in Microsoft SQL Server Management Studio Express GUI:
Update: Adding more information about SQL instances running based on answer, and requesting update to answer on how to add/ access & flush this DB instance.