creating a site collection in an existing Database
Hi all,
I need to create a site collection in an existing database in a specific Web Application.But the content database is being taken automatically.it is not asking which content database in that web application or the new site collection to be created.Does this
require custom Coding..? or sharePoint Provides an OOTB Feature to create a Site collection in a content database.
Example to my Scenario:-
I have a Web Application WA and it has several content databases such as a,b,c...f
I need to create a site collection in a content database d .How can I do this in SharePoint? Is this OOTB or custom...?
Presently it is taking e as default content database.(lets say)
Please direct me.
Thanks
December 30th, 2010 7:36pm
Hi,
This post will help you.
http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/151913b1-6520-4932-b375-e776a3d7f5fc
http://blogs.msdn.com/b/mcsnoiwb/archive/2007/08/20/how-to-create-site-collection-in-a-specific-content-database.aspxCheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"
Free Windows Admin Tool Kit Click here and download it now
December 30th, 2010 7:55pm
If you want to use STSADM via the command line, you can use the Createsiteinnewdb operation (http://technet.microsoft.com/en-us/library/cc262407%28office.12%29.aspx ) to
create the site collection in a brand new content database. But unfortunately the Createsite operation follows the same rules as the Central Admin site and doesn't let you specify a content database, so if you want to use an existing DB Hemendra's information
is your best bet to review.
JohnMCTS: WSS v3, MOSS 2007, and SCOM 2007
MCITP: Enterprise Project Management with Project Server 2007
Now Available on Amazon - The SharePoint 2010 Disaster Recovery Guide. Also available -
The SharePoint 2007 Disaster Recovery Guide.
My blog: My Central Admin.
December 30th, 2010 8:26pm
Hi Hemendra and John,
Thanks for the Reply.I have founded the workaround for this issue. I just make the content Database as offline and only database that needs to be active is the one in which I want to create a Site collection. Hemendra's material helped me in doing this.Thanks
for that.I have one more small doubt regarding the number of sites in Content DB.The Warning number which we provide while creating a content database in Central Admin ,Does that number reflect Site collections or just sites.because if it signifies sites then
all sub sites will be under consideration right..?Please clarify it.
Thanks
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2010 11:40am
The number of sites listed in each content database is the number of site collections in it, not counting subsites in any way.
JohnMCTS: WSS v3, MOSS 2007, and SCOM 2007
MCITP: Enterprise Project Management with Project Server 2007
Now Available on Amazon - The SharePoint 2010 Disaster Recovery Guide. Also available -
The SharePoint 2007 Disaster Recovery Guide.
My blog: My Central Admin.
December 31st, 2010 9:11pm
The number of sites listed in each content database is the number of site collections in it, not counting subsites in any way.
JohnMCTS: WSS v3, MOSS 2007, and SCOM 2007
MCITP: Enterprise Project Management with Project Server 2007
Now Available on Amazon - The SharePoint 2010 Disaster Recovery Guide. Also available -
The SharePoint 2007 Disaster Recovery Guide.
My blog: My Central Admin.
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2010 9:11pm