My main DBA returned and we confirmed it's a permission issue as I suspected after granting and revoking db_owner role.