locked
Sharepoint service 2.0 splitting databases RRS feed

  • Question

  • I have an issue with  SharePoint Services 2.0 with the fact that one database is 726Gb and another is 216GB, I would like to split these down to more manageable sizes (under 100Gb).  Are there any tools available to do this without having to upgrade to 2007 first?

    Murray


    • Edited by Mike Walsh FIN Monday, August 15, 2011 2:25 PM All mentions of SP 2010 off-topic in pre-SP 2010 forums. If you ask a question about upgrading to SP 2010 it goes to a SP 2010 forum. Questions here are purely SP 2007 or SP 2003 or SP 2001 questions or questions about a mix of some of those products
    • Moved by Mike Walsh FIN Monday, August 15, 2011 2:25 PM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Monday, August 15, 2011 2:19 PM

All replies

  • Since SharePoint 2003 is far beyond its product life cycle finding reliable tools or supported ones is somewhat tricky.  Considering Mike has deleted "the product that shall not be named", I assume you're looking to upgrade your current deployment to the most recent version of the technology.

    Having had a look on CodePlex, there's nothing of use within its projects.  From personal experience I can suggest this tool, which will help with migrations and content database splitting.  Have a look and let us know what you think: -


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Monday, August 15, 2011 4:39 PM
    Answerer
  • Hi Steve,

     

    Thanks for that pointer, it looks interesting, I'll give it a go tomorrow and report back.  Many thanks.

    Murray

     

    Monday, August 15, 2011 5:11 PM
  • Hello Murray,

    Its good to split these Content DBs to managable size as they are well beyond the recommended size for SPS 2003 / WSS 2.0 databases. You could use SharePoint Site Manager which allows the administrator to batch backup, delete, restore and repartition sites across content databases.

    The SharePoint Utility Suite (SPUserUtil) - http://blogs.msdn.com/b/krichie/archive/2005/07/15/439453.aspx

    Note: Most download links are probably dead as we've had two SharePoint product releases after SPS 2003 :) so if you're unable to find a working link then please let me know and I'll email the zip file to you.


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Regards,
    Nishant Shah
    Microsoft Online Community Support
    Friday, August 19, 2011 1:43 PM
    Moderator
  • Nishant,

    I´ve used this recently and have spoken to Keith a few times.  He also keeps his tools uploaded here

    http://blog.krichie.com/my-sharepoint-tools/

     


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Friday, August 19, 2011 2:15 PM
    Answerer
  • Thanks for providing a working link Steven.

    http://spsitemanager.codeplex.com/releases/view/9865 


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Regards,
    Nishant Shah
    Microsoft Online Community Support
    Monday, August 22, 2011 8:42 AM
    Moderator
  • I got the tool from the link provided by Steven, I'll give it sa go and report back.

    Murray

     

    Monday, August 22, 2011 1:23 PM