Hey Guys,
I've got a 17GB progress database that I'm running or I should say that I've got 17GB worth of space allotted for this database. What I'm trying to find out is how can I go about getting the EXACT SIZE of the database and which extent it is currently using. Please note that I need the exact size of the database.
I have 15 DB extents assigned to my database but I don't truely no the exact size of the database other then relying on the size of the nightly backup. Which isn't the most accurate means of tracking database size and doesn't tell me which extent the database is currently in or by how much that database has grown over the span of time.
I'm trying to create a report that I can hand of to management so that they can see how quickly the database is growing. I've created several reports like this in SQL Server and I'm hoping that I can generate one for Progress that can be schedules automatically. Does anyone know how I can go about getting this information from the database into a usable file format that I can import into SQL Server and generate a report. Thanks in advance for all the help.
Thanks,
Pete J.
I've got a 17GB progress database that I'm running or I should say that I've got 17GB worth of space allotted for this database. What I'm trying to find out is how can I go about getting the EXACT SIZE of the database and which extent it is currently using. Please note that I need the exact size of the database.
I have 15 DB extents assigned to my database but I don't truely no the exact size of the database other then relying on the size of the nightly backup. Which isn't the most accurate means of tracking database size and doesn't tell me which extent the database is currently in or by how much that database has grown over the span of time.
I'm trying to create a report that I can hand of to management so that they can see how quickly the database is growing. I've created several reports like this in SQL Server and I'm hoping that I can generate one for Progress that can be schedules automatically. Does anyone know how I can go about getting this information from the database into a usable file format that I can import into SQL Server and generate a report. Thanks in advance for all the help.
Thanks,
Pete J.