How to determine which site collection is associated with which db? RRS feed

  • Question

  • I have a site collection that contains a number of other site collections. I've created a content DB in a new SQL instance, and, within another site collection, specified that DB is associated with a new site collection, eg:

    New-SPContentDatabase "sitecollection9_content" -DatabaseServer "spsqlserver\newinstance" -WebApplication http://spintranet

    New-SPSite -url http://intranet/sites/sitecollection9 -ownerAlias "domain\user123" -contentdatabase "sitecollection9_content" -template "STS#1" -Name "sitecollection9"

    I wish to confirm that sitecollection9 is using only newinstance\sitecollection9_content.

    How can I do so?



    Thursday, April 9, 2015 3:12 PM


  • Site collection within site collection doesn't exist. you may have different site collection on a WebApplication.

    you can check what is the Database associated with a site collection through powershell

    $site = get-spsite <URL of your site collection>

    • Proposed as answer by Alex Brassington Thursday, April 9, 2015 3:35 PM
    • Marked as answer by scogordo Thursday, April 9, 2015 4:46 PM
    Thursday, April 9, 2015 3:31 PM