How to see all site collections in a specific content DB

Question

How can I see all site collections associated in a specific Content db in SharePoint 2010?

Any advice or suggestion is highly appreciated.

Answer 1

Get-SPSite -Limit All  -ContentDatabase contentdbname | select url, @{label="Size";Expression={$_.usage.storage}} 

Answer 2

This can also be achieved by

get-spsite -limit all | select url,contentdatabase

The output gets you all of your content databases and the site collections contained within. The -limit all would help if you have more than 100 site collections.

Answer 3

It's easy, just look in the documentation and here it goes: SPContentDatabase.Sites.