Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

WSS_Content

Can we attach one more WSS_Content database to an existing web application, eg http://portaldev/ ? If yes, what's the normal application for this ?

If there are two database attached to it, does the web application use either one or both of them.
0
AXISHK
Asked:
AXISHK
3 Solutions
 
Jamie McAllister MVPArchitectCommented:
You can have multiple content databases, but only one per site collection. (Many per application)

http://alkalony.wordpress.com/2009/08/25/add-existing-content-database-to-a-site-collection-using-stsadm/
0
 
Mohammed KhawajaCommented:
Relationship is one web application can host only one content database.  To add to this, you cannot make a copy of a content database and then attach it to a different web application on the same server (some people want to have a test environment on the same server)
0
 
Jamie McAllister MVPArchitectCommented:
It's possible to have 500 content DBs per Web Application;

http://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Mohit NairCommented:
You can have 500 content database per web application. But your site collection will use only 1 database. 1 database per site collection. In your case , http://portaldev/ is your root site collection which already has a database.Adding one more will not help.
In case you are creating one more site collection in that web app then you can go and create new database from central admin > operations > manage content database > Add a database. Give a name and it would get created in SQL. Bring Wss_content in offline mode.Create a site collection and then you would find new site collection will use new database. Now you can bring WSS_Content in ready mode.
0
 
AXISHKAuthor Commented:
There are two content database mounted to http://portal:8888. How can I know which content database does "8888" use ? Tks

PS C:\Users\Spadmin> Get-SPContentDatabase

Id               : 89062ad1-1b72-4715-82d8-e0810d48333f
Name             : WSS_Content_612bcdd3165d43edb89e3700511204d7
WebApplication   : SPWebApplication Name=SharePoint - 8888
Server           : SPDB01
CurrentSiteCount : 1

Id               : c495bcf7-e3e0-492f-818c-636a9792f45f
Name             : Portal_SPSRV
WebApplication   : SPWebApplication Name=SharePoint - 8888
Server           : SPDB01
CurrentSiteCount : 49
0
 
Jamie McAllister MVPArchitectCommented:
Central Admin -> Application Management -> View All Site Collections

The Content DB for each Site Collection is listed.
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now