locked
Sharepoint log question RRS feed

  • Question

  • Running SBS 2008.  The log file named ShareWebDb_log.ldf is 46gb in size.  The ShareWebDb_log.mdf file is only 17gb in size.  Is there a way for me to reduce the size of the ShareWebDb_log.ldf file?
    Thursday, October 1, 2009 9:05 PM

All replies

  • I have the same issue with a SBS 2008 over here.
    Friday, October 9, 2009 7:42 PM
  • Not sure if this is the best approach but here is what I did to reduce the file size:

    1 - Start SQL Management Studio and connect to the server:  \\.\pipe\mssql$microsoft##ssee\sql\query
    2 - Backup the database
    3 - Open the properties window of the database
    4 - Select Options
    5 - Changed the recovery model to simple
    6 - Tasks -> Shrink -> Shrink Files
    7 - Change the File Type to log and then activate the "OK" button.

    Here is more information on Full vs Simple recovery model:

    http://msdn.microsoft.com/en-us/library/ms189275.aspx
    Saturday, October 10, 2009 2:37 PM