|
| Hi All,
Can you please tell me how to validate the database objects (Datafiles,
filegroups, log files) attribute like occupied space,freespace and size in
SQL Server 2005.It would-be great help if I get SQl queries from SQL guru's.
I am finding the lot of different when I compare SQL server 2005 Server
manager Studio output with SQL 2000 DMO explorer output.
I created a database by the name 'eval' and compare the output=20
Output from SQL-DMO:
****************
1. Total Size of Datafile: 3 MB
2. Free Space: 1 MB
OCC_SPACE =3D 2MB (Total Size - FREE_SPACE-)
Output from Server Manager Studio:
********************
************
1. Total Size of Datafile: 3 MB
2. OCC_SPACE(Space Used) : 1.38
The difference is 635 kb. Can you please tell me why I am seeing the huge
difference?
********************
********************
********************
***
One more doubt related to above Query...
Recently I read one article in that author mentioned that most of the system
table in SQL 2000 becomes system views in SQL 2005. This will effect the
database size calculation?
Also SQL server 2005 based on .net frame work uses SMO components and SQl
2000 uses DMO components.So when we use DMO component to access SQL server
2005 database.=20 Does it shows accurate data for database size and for
other attributes or it will fail to collect all thee details...if it so..what
will be the missing one's
Please help me...
Awaiting for your reply..
Suresh
|
|