SQL Server 2008R2 Issue: "Property Size Unavailable for Database [] ..."

Question

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

The size of the property is not available for the database [database name], this property may not exist for this object or cannot be retrieved due to insufficient access rights (Microsoft.smo ..)

Is there any way to solve this?

Answer 1

I found that my database was physically damaged due to hardware problems :(. Thanks to everyone for the answers.

Answer 2

, . , , , , . .

, ? , , .:)

Answer 3

, . , DBCC UPDATEUSAGE .

Answer 4

, . . , , .

Answer 5

, .

DBCC UPDATEUSAGE(database_name) 

regarding the database, and it fixed the problem, but I see where others had to reset the owner of the database in order to fix this problem. You can see the database owners by running

sp_helpdb

You can change the owner by running

sp_changedbowner [ @loginame = ] ‘login’
                         [ , [ @map= ] remap_alias_flag ]}