find the size of data base

[samerendra]

Hi all

plz gives the exat query for finding size of database


Thanks
Samerendra Singh

[srinit]

Hi all

plz gives the exat query for finding size of database


Thanks
Samerendra Singh

Hi Samerendra Singh,

You can find the size of the data base by right clicking on the data base go to properties you can find the data base size

[LakshmiAlagappan]

Hi Samerendra,
hope this helps you
The following statement returns the file size of the system dbspace, in pages.

SELECT DB_EXTENDED_PRO PERTY( 'FileSize' );

if u want to check rightclick ur .db file inside sql win32 folder and chek for the size occupied.

Hi all

plz gives the exat query for finding size of database


Thanks
Samerendra Singh

[LakshmiAlagappan]

even if u need ur page size value to calculate this query will gice the page size allocated in bytes
SELECT DB_PROPERTY ( 'PageSize' );

Hi all

plz gives the exat query for finding size of database


Thanks
Samerendra Singh