Database Size

Question

Database Size

Nita Reddy

SSCarpal Tunnel

Points: 4177
More actions
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

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

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

cross SSCommitted Points: 1735 More actions · Answer 1

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.

franzambesten SSCommitted Points: 1693 More actions · Answer 2

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

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

Nita Reddy SSCarpal Tunnel Points: 4177 More actions · Answer 3

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

Nita

PMar Mr or Mrs. 500 Points: 569 More actions · Answer 4

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.

Jon Russell Hall of Fame Points: 3048 More actions · Answer 5

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