Migrating from standalone to farm RRS feed

  • Question

  • I am having issues of database storage whereby the only solution i can see for our sharepoint deployment at present is to migrate our 32 bit standalone installation to a new 64 bit Farm installation using sql 2008 express, can this be done? if so what do i need to look out for, i have a large document control workflow that is the most important part of our sharepoint wssv3 environment.
    Wednesday, June 16, 2010 7:26 AM


  • You are probably in your standalone WSS 3.0 installation using the default version of SQL Server 2005 Express (called the "Windows Internal Database" which does not have a limit on the size of databases.

    Moving to a farm installation of WSS 3.0 with the normal version of SQL Server 2005 Express (you can no longer use the Windows Internal Database once you move away from the single server solution) means that you will then have a database size limit of 4GB. 

    If you do move to a farm installation you should therefore seriously consider moving to full SQL Server 2005 in order to regain your unlimited database sizes.


    P.S. This http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/EditForm.aspx?ID=137 (Databases: How do you move the "Windows Internal Database" (embedded SQL Server 2005 Express) to a different drive than C:) might help you with the actual move. (My site using information from Sylvain Dinel)

    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    • Edited by Mike Walsh FIN Wednesday, June 16, 2010 8:14 AM P.S. added
    • Proposed as answer by André Lage Wednesday, June 16, 2010 2:19 PM
    • Marked as answer by Stanfford Liu Thursday, June 24, 2010 6:31 AM
    Wednesday, June 16, 2010 8:11 AM