Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
SharePoint database log file is getting large in Windows SBS 2008
Article ID: 2000544 - View products that this article applies to.
The Windows SharePoint Services 3.0 (WSS) log file may grow to a large size on a default installation of Windows Small Business Server 2008 (Windows SBS). The Windows SBS Best Practices Analyzer (BPA) reports the following warning message:
Sharepoint Config database log file getting large
The Windows SharePoint Services configuration databases log file is getting large (currently over 1gb in size)
This will occur if the database is configured to use the default setting of full recovery mode and numerous transactions have been logged to the database.
To reduce the size of the log file, follow these steps.
Note It's a good idea to do a full server backup before you complete these steps.
To fix this problem automatically, click the Fix this problem link. Then click
Run in the File Download dialog box, and follow the steps in this wizard.
Fix this problem
Microsoft Fix it 50682
1. Start Notepad. To do this, click Start, point to All Programs, point to Accessories, and then click Notepad.
2. Copy and paste the following text into Notepad. Save the file as c:\logshrink.sql
declare @ConfigDB varchar(255);
3. Open an elevated command prompt. To do this, follow these steps:
4. At the command prompt, copy and paste (or type) the following command, and then press Enter:
sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -i c:\logshrink.sql
Note This script creates two backup files (before.bkf and after.bkf) in C:\windows\temp.