The SharePoint Config log DB can grow quite large! The following way can help you shrink the config databases. But do only use these in test or development enviroments! SharePoint 2010 on SQL 2008 R2 Right click on you DB -> Properties Select Options Change the Recovery Model to SIMPLE and Click Ok Once that…
To create the asp.net membership database, please follow the steps below. Find the setup file aspnet_regsql.exe located at either of the following locations depending upon your OS:%windir%\Microsoft.NET\Framework\v2.0.5027%windir%\Microsoft.NET\Framework64\v2.0.5027 When the ASP.NET SQL Server Setup Wizard appears, select “Configure SQL Server for application services”, then click Next Enter the SQL Server and Database name. Click…