Post reply

Size of site collections...

  • November 28, 2005 at 12:30 pm

    #110390

    Hi All,

    Is there any query or simpler method to get the sizes of individual site collections in a database?I'm currently obtaining this from the EM by going thru each and every database.

    The dev. team wants to have a statistic output of this for every site collection in each DB..

    is there a way to do this?

    Thanks,

    AK.

  • November 28, 2005 at 2:03 pm

    #606228

    Arun - I don't understand what "site collection" means...if you're talking about a list of databases and their sizes, you could do exec sp_databases to get your results..else someone who has a better grasp of the requirement may come along with the right answer...







    **ASCII stupid question, get a stupid ANSI !!!**

  • November 28, 2005 at 3:01 pm

    #606238

    Yeah,this is true..this procedure gives the direct sizes of all db's.By site collection i mean..like we have different sites for different departments and each top level site is associated with one content db in the server.so,low level sites created under one particular top level site collection has all its data stored in the respective content db..

    i want to generate the report to find the space occupied by each top level and low level sites created in the db..

    hope i've explained it clear without too much verbose..

    do u've any idea how to achieve this?

    Thanks for ur time..

    AK.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply