I'm running WSS 3.0 (SharePoint 2007 free equivalent) on my Windows Server 2003 Standard editon 32 bit.
Can anyone please shed some light in regards to the size of SQL Server log files and the database ?
Browsing to C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data I can see that there are the following files:
WSS_Search_PRODWSS01.mdf --> 560 MB Database file
WSS_Search_PRODWSS01-VM_log.LDF --> 3.2 GB Log file
How is that happening ?
my only understanding is that the database file should be larger than the log files.
Is there any way to shrink the log file in the SQL Server Express 2005 edition ?
Thanks in advance.