I was told to fix some issues on sharepoint 2010 farm having single server installation. When i checked the SSMS, I came to know that they have installed use a
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)
Is this a correct installation procedure? Will I have to switch to Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Standard or Enterprise environment? Will MSFT support/recommends this express edition on a sp 2010 single server Production env?
Also , i am facing the logs issue on teh c drive of this prod.server. every 30 minutes some 150 MB files of log files were generated hence deeply affecting the appln performance.