Post reply

Database Size

  • November 27, 2007 at 2:01 pm

    #122526

    I need to know the server configuration of my SQL Server how to get it in SQL 2000?

    I want to know weather it is Auto-Grow or not?

    I want to know the DB space used and size allocated to that DB.

    Nita

  • November 27, 2007 at 2:32 pm

    #754736

    You can easily find this information by using SQL Server Management Studio (SSMS). Go to Databases/{the data you need info about} Click the database name and right click for the menu, then select Properties. The various pages of database properties will tell you all the items you mentioned.

  • November 27, 2007 at 2:35 pm

    #754737

    Hi, you can obtain information about your db making the following query

    select * from sys.database_files in the context of your db

  • November 27, 2007 at 2:46 pm

    #754742

    I have 50 DB and its on 2000, also how can I get my database configuration setting.

    Nita

  • November 27, 2007 at 3:49 pm

    #754760

    Use the following SQL to get information on auto grow for all databases.

    use master

    go

    select * from sysaltfiles

    Column name 'maxsize', a value of 0 indicates no growth, and a value of -1 indicates that the file should grow until the disk is full.

  • November 27, 2007 at 3:55 pm

    #754765

    Nita,

    These recommendations will answer all your questions. Everything you need is on the property pages as Cross recommends. To add to his comments, take a look at the Options tab. On this tab you can view the Compatability Level (2000 or 2005), the recovery model, and all the other options. The database size is on the General tab. The auto-grow options are on the Files tab.

    Regards,

    Jon

Viewing 6 posts - 1 through 5 (of 5 total)

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