SQL Server 2016 standard edition, with primary databases and one other server set up as secondary failover with always on availability group.
There were some issues over the weekend with an application that accesses the databases on this server, unbeknownst to me, they decided just to reboot the database server, which seemed to clear things up with the application.
This morning I was checking the databases, as I was going through the emails I was cc'd on it looked like there was permissions issues with tempdb for one of the databases. One of the databases will not display a properties window, giving the property spaceavailable is not available for database 'x'message.
I checked the ownership of the databases with a query to make sure it wasn't set to "unkown", and it is owned by a domain service account that owns another database (that I am available to see the properties of).
Doing some more reading of this (properties) error I see the easiest method to deal with this seems to be just to change the dbowner to sa then change it back. However I also read this can be an issue with failover databases with ownership changes not going over to the failover database.
Is this an issue I need to be concerned about, if I am changing the owner to sa then back to original owner?
Is there a better way to fix the unable to see properties window in this particular database?
thanks in advance.