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
**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.
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:


Asked by Alex S
(101 rep)
Apr 16, 2016, 09:41 AM
Last activity: Jul 18, 2022, 08:00 PM
Last activity: Jul 18, 2022, 08:00 PM