dougcoulter
Programmer
Hello everyone. I am trying to determine the size of an MSDE database. In another thread, a couple of system stored procedures were recommended, but I still have a couple of questions.
From my research, it appears that each individual database within an MSDE installation is limited to 2GB - as opposed to the cumulative database size - is this correct? Also, it seems like the limitation is based on the data file only (mdf), not including the log file - is this correct?
I have tried to simulate reaching the 2GB barrier by simply creating a new database with a data file with a space allocation of 3GB - MSDE allows me to do this, so I am assuming the barrier is reached when the data within the allocated space reaches 2GB.
I first implemented the sp_spaceused stored procedure on the this 3GB test database (called Sample), and it returns a database_size of 3001.00 MB and unallocated space of 2999.48 MB. The second row of information: reserved = 536 KB, data = 152 KB, index_size = 280 KB, and unused = 104 KB. Based on this information, what would tell me how close I am to the 2GB threshold?
Similarly for the sp_helpdb stored procedure, it returns a db_size column, which for the Sample database is 3001.00 MB.
Can anyone offer any insights? Again, what I would like to do is to check on a nightly basis how close a database is to the 2GB barrier, and perform some tasks say if it is within 80% of 2GB.
Thanks!
From my research, it appears that each individual database within an MSDE installation is limited to 2GB - as opposed to the cumulative database size - is this correct? Also, it seems like the limitation is based on the data file only (mdf), not including the log file - is this correct?
I have tried to simulate reaching the 2GB barrier by simply creating a new database with a data file with a space allocation of 3GB - MSDE allows me to do this, so I am assuming the barrier is reached when the data within the allocated space reaches 2GB.
I first implemented the sp_spaceused stored procedure on the this 3GB test database (called Sample), and it returns a database_size of 3001.00 MB and unallocated space of 2999.48 MB. The second row of information: reserved = 536 KB, data = 152 KB, index_size = 280 KB, and unused = 104 KB. Based on this information, what would tell me how close I am to the 2GB threshold?
Similarly for the sp_helpdb stored procedure, it returns a db_size column, which for the Sample database is 3001.00 MB.
Can anyone offer any insights? Again, what I would like to do is to check on a nightly basis how close a database is to the 2GB barrier, and perform some tasks say if it is within 80% of 2GB.
Thanks!