How To: Reduce SharePoint database log file size?

Sometimes, your SharePoint server space may be very low. This is because, the SharePoint server database log will be increased slowly day by day.
For example, you may have 30 or 40 GB free space in C drive, when you installed SQL Server in your database server. After 1 or 2 months, your database server C drive may be very low. So that you will get "Low disk space" error. This is beacuse, the log file size will be high.
So, here I am going to explain, how to reduce the size of the Database log file size to 1MB.

1. First open your SQL Server management studio 2005.
2. Click "New Query"
3. Type the below Command. Here, "WSS_Content_10002" is my database name. replace this text with your database name.
BACKUP LOG [WSS_Content_10002] WITH TRUNCATE_ONLY
USE [WSS_Content_10002]
GO
DBCC SHRINKFILE ('WSS_Content_10002_log' , 1)
GO

Finished. Now, you can see that the free space in C Drive will be increased.

Error: The application is unable to accept further updates because the last attempt to persist the state failed. See the event log for more details

Error:
The application is unable to accept further updates because the last attempt to persist the state failed. See the event log for more details

Solution:
Sometimes you will get this error, when you configure the search in sharepoint server. Do the below steps, one by one.

1. Go to central admin
2. Go to Operations Tab.
3. Click on "Services on Server" link and Stop the "Office Sharepoint Server Search"
4. Again, start the "Office Sharepoint Server Search".
5. Go to SSP & Search Settings.
6. Here you have to configure again the search settings.
7. Then, It will take few minutes to complete teh operation. (based on the Timer execution).

Thats it...