locked
Migrating site from WSS 3 Standalone to MOSS small farm? RRS feed

  • Question

  • Hi all,

    I have a 10GB site on a WSS standalone box that I need to migrate to a MOSS WFE, Index, and SQL server farm.

    I'm trying a basic db restore:

    1. created a backup of the WSS site's DB (named WSSSiteDB) and restored it to the MOSS farm
    2. created a sharepoint site and collection with a db (named MOSSSiteDBDelete)
    3. used stsadm -o addcontent db to add it to my new site's DBs

    In CA, when I remove MOSSSiteDBDelete, the site breaks. WSSSiteDB also lists 0 sites, even though there should be 5. Using http://www.shannonbray.com/2008/04/current-number-of-sites-is-0.html, I opened the WSSSiteDB and go the ID. However, when I checked it against the Sharepoint_Config's Id column, there was no match.

    Any suggestions? Better routes to take?

    Much thanks.

    Friday, September 9, 2011 3:04 PM

All replies

  • Is the WSS 3.0 standalone box using the built-in database system (WID) ?

    What database system is your MOSS 2007 using ?   (It looks like full SQL Server from what you write, but just to be sure - which year version of SQL Server?)

     

     

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Friday, September 9, 2011 3:16 PM
  • 10GB is within the suggested guidelines for an STSADM export/import or back-up restore.  I'd suggest going this rought BUT clear out your recycle bins and second stage administration bins first, as this could cut down your quota quite significantly.
    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Friday, September 9, 2011 3:17 PM
    Answerer
  • Thanks guys.

    Mike: WSS Server uses SQL Express 2005, MOSS farm uses SQL 2005. All servers are Win2003 SP2.

    Steven: I did try to export the site, but ran into "FatalError: Feature 'd8d8df90-7b1f-49c1-b170-6f46a94f8c3c' for list template '1104' is not installed in this farm." The operation could not be completed. After a bit of googling it sounds like MS Project may have been installed and uninstalled (I inherited this server and don't know its history). It's a production server, too, so I'm a rather wary of installing/removing software on it. And, presumably, down the line these features might need to be installed on the server I'm migrating to, which is adding to my headache.

    Again, much appreciated.


    • Edited by Mike Walsh FIN Friday, September 9, 2011 6:23 PM SP 2010 question removed. Both off-topic here and a new question in a thread that already has a question. Post that new question in the "Upgrade" SP 2010 forum!
    Friday, September 9, 2011 3:42 PM
  • I can't/wont answer the 2010 question as Mike will scowl horribly at me, and well, he's just a scary dude.

    My answer assumed that your current farm didn't have any customisations or third party / additional MS stuff on it.

    Can you check out the site collecton features page and let us know what's there?  Ideally, you'll want the same features here installed on your target farm.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Friday, September 9, 2011 3:49 PM
    Answerer
  • I hear you Steven ;)

    It's WSS, so I don't believe there's Site Collection Features, but under Site Features there's Team Collaboration Lists. It's Active under all Sites.

    Friday, September 9, 2011 4:42 PM
  • > Mike: WSS Server uses SQL Express 2005, MOSS farm uses SQL 2005. All servers are Win2003 SP2.

    Just to make quite sure that we are on the same page.

    So WSS 3.0 does *not* use the built-in version of SQL Server Express 2005 called "Windows Internal Database" (WID) that I thought it probably did, but used a copy of SQL Server Express 2005. (A possible option but not the usual one for a single server WSS 3.0 installation).

     

    Mike (scary, what me?)

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Friday, September 9, 2011 6:25 PM
  • Whoops! Sorry, right, WID. This is my first single-server WSS installation, always thought it was SQL Express.
    Friday, September 9, 2011 7:22 PM
  • Just wanted to bump this thread and see if anyone had any new ideas. Again, much thanks.
    Thursday, September 15, 2011 2:27 PM