Disk full

[Dilbert]

I am running WSUS setup on my system partition that has only 12gb space and just now, the disk became full because of the 2 WSUS files that are using more then 1.4gb each. So, can anyone tell me what should I do to reduce the size of this files, is it possible to move the 2 files on any other partition? Thanks for any information.

[Killen]

All you need to do is restart service MSSQL$WSUS and then the *.ldf files gets empty, all by itself.

[Dilbert]

Thank you very much, I only have now 1.8gb size, so can you tell me if I can replace this files somehow? Thanks.

[Jasonholt]

It seems to me that the database server has the SUSDB database configured in Full Recovery mode. So, you might need to convert the SUSDB back to Simple recovery mode to eliminate the autogrow of the LDF file.

[Dr.Jones]

You can try to recover from a full transaction log in a SQL Server database. Full transaction logs can make your Microsoft SQL Server database unusable. This article describes how to truncate and shrink the transaction logs when they grow too large. For more information you can visit the full article here - http://support.microsoft.com/kb/873235/en-us