Masuk
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Sharepoint log question

Locked Sharepoint log question

  • 01 Oktober 2009 21:05
     
     
    Masuk untuk Memilih
    0
    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?
       

    Semua Balasan

    • 09 Oktober 2009 19:42
       
       
      Masuk untuk Memilih
      0
      I have the same issue with a SBS 2008 over here.
         
      • 10 Oktober 2009 14:37
         
         
        Masuk untuk Memilih
        0
        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