April 21, 2020 at 12:01 pm
Hi everyone
We're in the process of moving our database over to a new supplier, and they've asked for the size of our current db.
Using the stored procedure EXEC sp_spaceused I find that the database_size is 11918.81bm (so almost 12gb). However, I also get sizes of data = 6144880kb and index_size = 1559784kb (so a total of around 7.7gb).
So, it the database_size an arbitrary size that is set up by the person who created the database, and therefore the actual size is 7.7gb?
Many thanks
Jon
April 21, 2020 at 3:10 pm
Jon
What are they interested in - the size it's going to take up on disk, or the size of the actual data in it? Just add up the sizes of the data and log files. For the latter, subtract the value of Space Available in the General tab of the database properties in SSMS. Bear in mind that the figure you end up with will include the size of records in the transaction log.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply