How do I manage the SharePoint Config Database, the LDF file is over 15GB, and the SQL managment Studio doesnt show the Database
Posted on 2012-03-31
I have an SBS 2008 Server with Sharepoint installed, I cannot manage the database in SQL to truncate or shrink the .LDF file that is 15GB. I have SQL 2005 managment studio express but dont know how to open the .MDF file or .LDF file. My SQL managment studio only lets me open ,the SBSMonitoring and a few other Databases we have in office. Once I open them I can shrink it or back it up and that should eliminate the LDF file.