Sample Header Ad - 728x90

Clear out remnant LDF log files of Sharepoint DB not visible on SBS 2008 Domain Server?

0 votes
1 answer
554 views
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 [Link](https://web.archive.org/web/20210121185921/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: enter image description here **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. enter image description here
Asked by Alex S (101 rep)
Apr 16, 2016, 09:41 AM
Last activity: Jul 18, 2022, 08:00 PM