SQL Server 2008R2 problem: "Property Size is not available for Database []..."

Question

when i try to view properties of my database, i get this error:

Property Size is not available for database [database name] this property may not exists for this object or may not be retrievable due to insufficient access rights (Microsoft.smo..)

Is there any way to solve that?

Answer 1

Sometimes this kind of error is encountered when you are not the database owner. I'm not that sure though but, this might be worth a try. Check on the database owner, and try to change it to the current logged-in user.

By the way, is this a production database? You need to do a simulation on a test database to make sure, I strongly recommend not to do trial and error stuff on the production server. :)