determining size of SSAS databases

• Steve T

  SSCommitted

  Points: 1994

  More actions

  March 16, 2022 at 8:08 pm

  #4000851

  I'm trying to figure out what the size of the SSAS databases are on my system.

  I can right-click > Select Properties.  The size shows 6852MB which translates to 6.8GB.  I did a backup of the database and the compressed backup is approximately 21GB.  There seems to be a big discrepancy there.  The un-compressed backup shows its at about 80GB.

  I've looked at a few articles with powershell scripts, but they all return back the 6.8GB.  So I must be missing something to makes up the total size of the database.

• Site Owners

  SSC Guru

  Points: 80381

  More actions

  March 17, 2022 at 8:10 pm

  #4001553

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.