locked
Create Sharepoint WSS site on network storage device RRS feed

  • Question

  • I am the designer for our network and am trying to help our administrator or IT manager.

    I want to launch a new version of our intranet but storage space is an issue. Our IT guy bought a network storage device (2T Raided) but cannot figure out how to facilitate the creation of a new site upon this device.

    Can someone give us a hand with this?

    Wednesday, August 24, 2011 2:14 PM

All replies

  • (Very quick hint)

    You need to investigate forcing the system to create a new content database. Once you have that you can create a new site (warning: might need to be a new site collection) and it will be created in that new content database.

    I.e. concentrate your Google searches on creating a content database.


    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
    Wednesday, August 24, 2011 2:23 PM
  • Thanks for the reply. I did do a search at your prompting and found a TechNet video which explained the creation of the database. Not seeing a selection for the path, I surmised doing this would also require the addition of creating a new web application. Pulling up that window, I see the selection to designate a path. At present, it defaults to a C:/???/?? location.

    Am I correct that if we have a drive letter for the remote storage, that I can insert that location here, create the web application, create the content database and thus create my new site, all hosted on the new storage unit?

     

    Rob

     

    Wednesday, August 24, 2011 4:12 PM
  • To expand a little on what Mike has mentioned.  I'm not sure if it'll work on a detachable drive, but I don't see any reason why not.

    • Create a new SQL Server Database.  Make sure your temp drive is plugged in and visible via the Windows Manager.  When you're making the new database, you get to set the LDF/MDF locations.  Make sure these are set to your drive.
    • Make a new Content Database within SharePoint central administration that links to this new database and set the maximum site count absurdly high.
    • Create a new site collection, this will default to the content database with most space
    • Check the SQL Database size to see if the site content has been pushed here
    • Lower the content database site limit to something more appropriate

    SHould work, but let us know if you have any problems.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    • Marked as answer by Mike Walsh FIN Wednesday, August 24, 2011 5:54 PM
    • Unmarked as answer by Mike Walsh FIN Wednesday, August 24, 2011 5:58 PM
    • Marked as answer by R.E.Smith Thursday, August 25, 2011 6:23 PM
    • Unmarked as answer by Mike Walsh FIN Friday, August 26, 2011 7:47 AM
    Wednesday, August 24, 2011 5:02 PM
    Answerer
  • I'm running on ancient memories here but I think there is a parameter (or something else an admin can do [make read-only or similar??]) which will stop any new sites being created on the previously standard content database and thus move the new site to the new content database as the only one now available.

    Your idea of defaulting to the content database with the most space at least isn't what I remember (but this is years ago).

    Mike


    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
    Wednesday, August 24, 2011 5:26 PM
  • It also occurs to me that if the original problem was that of lack of space, i is possible to move the existing content database from its existing location to another location with more space (by detaching it from the present location etc.)

    I have a post on how to do that in my WSS v3 FAQ site's FAQ part I think.

     

    (Blame the mark as answer on this portable's over-active keyboard - it's up to the Op to mark as the answer or not)

     

     


    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

     



    Wednesday, August 24, 2011 5:54 PM
  • It is a lack of space AND a poorly designed original site. So, we don't just want to move it.

     

    Is the procedure not:

    Create Web Application (designate location) -> Create Content Database -> Create Site collection???

     

     

    Steven, it appears you are saying the above with the exception of the Create Web Application (me) and Create SQL DB (you) as first steps. Are we saying the same thing, differently? I am still obviously new and new with terminology. Please advise.

    Thanks!

    Rob

     


    Wednesday, August 24, 2011 6:43 PM
  • Right, there's quite a few things to respond too here, so lets make sure that I'm understanding the question/needs properly.

    First of all, what version of WSS are we talking about?  2.0 or 3.0?  2.0 doesn't have the migratecontentdb but there are a few useful utilities.  Keith Ritchie's SPSite Manager is the best of these: -http://blog.krichie.com/my-sharepoint-tools/

    In regards to Mike's point on the read only, WSS 3.0 (via the GUI) has a read only setting for the ContentDB, all I could see at a glance for WSS 2.0 was the below.  There may be something in the commandline, but as Mike says, it's an ancient memory.  I'll defer to his superior knowledge if he recalls something I don't.

    Rob's original question was how to create a new site upon the new storage, not the migration of a current site / content database?  I think I answered that above, I can find the original MSDN Blog entry advocating that approach if needed. 

    In answer to your question Rob, that's almost correct.  When you create a SharePoint application, you can either create a new one or attach a current database to it.  If its a new database, you create a new root site collection, if it's a restored database, you'll probably have one there already.

    Hope that helps but please let me know if not.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Thursday, August 25, 2011 10:46 AM
    Answerer
  • Just for the record. I shouldn't have, but I was assuming WSS 3.0. I doubt if I can remember much about WSS 2.0 ...

    Mike

     


    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
    Thursday, August 25, 2011 12:09 PM
  • Gents,

    Thank you both. It is indeed 3.0.

     

    "In answer to your question Rob, that's almost correct.  When you create a SharePoint application, you can either create a new one or attach a current database to it.  If its a new database, you create a new root site collection, if it's a restored database, you'll probably have one there already." - Steven

     

    I will start from scratch. So, to just be sure, the steps are Create the Web Application, Create the new database within it and Create a Site collection?

     

    If so, it is tremendously easier than it seems at first glance. I am not sure what you mean (if I am correct) by "that's almost correct".

     


    Thursday, August 25, 2011 3:35 PM
  • You want to strategically ensure that the new site collections diverts to a new SQL database that's hosted on your new storage device?  In that instance it would be: -

    SQL DataBase --> New WSS Application (specifiy the SQL Server name and database name here) --> Root Site Collection

    Check this technet article for more: - http://technet.microsoft.com/en-us/library/cc287954(office.12).aspx

     


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Thursday, August 25, 2011 3:45 PM
    Answerer
  • Steven, I marked your answer appropriately. Thank you.

     

    However, I still think we have a disconnect. While in the admin, it appears that a site collection lives inside a content database and that a content database lives within a web application. That being the case, if our share terminology is correct, then the procedure would be to create a site application on new drive path, CDB within and SC within.

    Does this seem accurate to you? Just trying not assume anything. Sorry if it comes across persnickety.

     

    Thursday, August 25, 2011 6:26 PM
  • > Steven, I marked your answer appropriately. Thank you.

    If you as OP (starter of the thread; OP=Original Poster) mark a post in the thread as the answer then you are closing the thread as answered.

    In that case you can not "have a disconnect".

    So your choices are to either mark the thread as answered (and not continue trying to solve your original question) or to not mark the thread as answered and carry on trying to solve your original question.

    I'll unmark the mark you made because it seems to me you are saying that your original question is still open. Mark it again once you feel your original question has been answered.

    Moderator

    Note that *new* questions belong in a new thread. In that case marking a post as an answer is correct as the original question has been answered.

     


    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, August 26, 2011 7:47 AM
  • Mike,

    as you marked and unmarked the post as the answer, there was a perceived pressure to accept it as correct. While trying to secure the needed help for our processes, I have no intent of exacerbating people in their attempts to help. Giving someone credit, already determined as deserved, seemed to be appropriate and an encouragement to nail the last step.

     

    This is the strictest forum I have ever visited. You are the only moderator that I have EVER dealt with that has seemingly corrected every thread I post and I visit a lot of forums on a variety of topics. My goodness.

    Friday, August 26, 2011 2:59 PM
  • My marking (and unmarking the thread) was caused by an over-active mouse pad on this portable - nothing else.  (I wrote this in an earlier post here - "(Blame the mark as answer on this portable's over-active keyboard ").  I rarely mark posts as answers and with recent threads I do so only if the OP has indicated that his problem was solved.

    It's fine to give credit for posts but you need to be aware that as the starter of a thread, the moment you mark a post as the answer you are saying you have the answer to your question and the thread is therefore finished.

    If anyone else (a moderator for instance) marks a post as the answer, the origiinal poster in the thread still has to right to unmark it because it did not answer his question.

    Some people seem to think mark as answer is there to thank people for making suggestions. It's not. It's there to say the thread has an answer. Hence the green arrow alongside the post. Thanking people for making suggestions could be done by clicking on "Helpful". It gives points but doesn't shut the thread.

    The reason I lock threads where the OP has by marking a post as answer or by saying "that answered my question" in a reply (or both) is to clearly close the thread so that people both know the thread has its answer (as opposed to a thread marked as an answer where the OP hasn't said it is) and to avoid anyone adding new questions to the thread.

    You would be amazed at the number of times people think that (in the pre-SP 2010 forums in a post about MOSS 2007 from even 2008 or 2009) it's useful to say how things work or don't work in SPS 2010. You don't see them because I delete them and then lock the thread if there was a 2008/2009 answer in it.

     

    Mike


    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, August 26, 2011 3:14 PM