locked
SharePoint - content database transaction log files (LDF) RRS feed

  • Question

  • Using SharePoint 2007. Looking at content dataabse reveals that there is xxxx_log file next to each content database. It is taking lot of space and creating problems.

    Are Transaction log files for SharePoint necessary to keep the portal running? or can they be deleted? I had a look at

    http://support.microsoft.com/kb/873235

    Your help is appreciated.


    Apriori algorithm [association rule]
    Wednesday, December 8, 2010 11:37 PM

Answers

  • Hi,

     

    If you are using SQL 2008 just backup the transaction log and it should shrink it,
    If you are using SQL 2005 you can do:
    - backup the transaction log then shrinking the log file
    - use truncate log statement

     

    In addition, you can traction log file with PowerShell.

    http://sharepoint.microsoft.com/Blogs/fromthefield/Lists/Posts/Post.aspx?ID=111

     

    I wish you every success in your important work.

    Best regards,

    David Hu

    • Marked as answer by Peng Lei Thursday, December 16, 2010 8:38 AM
    Friday, December 10, 2010 2:00 AM

All replies