locked
Shrinking Transaction Logs for SharePoint 3.0 RRS feed

  • Question

  • I am trying to shrink the logs and databases for my SharePoint server and the only database engine I am seeing in SQL Server Management Studio on the server is the SQLExpress.  This is not the engine for SharePoint, so I am not sure how to connect to that to be able to shrink the logs.  I am running on of space on my server.  I noticed that the large database files are in C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data, does this mean I need to have 2005 Server Management Studio installed to connect to find the correct database?
    • Edited by MC_9874 Monday, March 7, 2016 2:52 PM
    Monday, March 7, 2016 2:45 PM

All replies

  • Hi 

    Full backup our database with log files and use the below command to shrink the log file

    DBCC ShrinkFile (Logfilename,minsize)

    karim


    Please remember to mark your question as answered, if this solves your problem.

    Tuesday, March 29, 2016 7:24 AM