Post reply

Need help regarding filegroup size and view.

  • November 18, 2004 at 2:42 pm

    #84257

    HI !

      I created one database. I have two file groups in this database. One carried all data (Table and all system info) and second carried all info about indexes. I allocted size 20MB for both group. If i want a see how much space i used and how much i have left with all detial about each object. How can i able to see this info.

     

    Thanks

  • November 19, 2004 at 8:46 am

    #530856

    Would EXEC sp_helpdb 'your db name goes here' be a start? Or in case when you prefer EM, setting the view option to taskpad?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 22, 2004 at 9:08 am

    #531072

    I tried that. It tell me how much i assiged for each filegroup. I would like to know how much space my filegroup already used and how much i have left in detail.

  • November 23, 2004 at 12:36 am

    #531170

    sp_spaceused?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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