Monday, May 7, 2012

SharePoint running on SQL Express

Great news for anyone planning to install SharePoint on SQL Express.  Make sure to first install the latest version since SQL Server 2008 R2 Express allowed for 10 GB database.  Note that the database limit was increased to 10 GB from the earlier 4 GB limit. After SQL express is running then install SharePoint in farm and do not use standalone.  But there is a registry entry you need to make.
http://mytechweblog.blogspot.ca/2012/05/search-server-2010-vs-sql-server.html

Do you need to convert to SQL? Geoff Schaller has a good comment on

http://www.eggheadcafe.com/software/aspnet/35842443/move-database-from-sqlexpress-to-sql-standard-wss.aspx

http://technet.microsoft.com/en-us/library/cc262018(office.12).aspx 

http://www.eggheadcafe.com/software/aspnet/35805720/move-databases-from-wss-sql-express-to-full-sql.aspx



More References
http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/0deed03e-376b-4540-87f7-bfd818ebd8fe

http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html

http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/870dde9a-ea60-4133-82fd-f6d25385f035

No comments:

Post a Comment