SQL Server: I have Always On setup. I get secondary database connection failure. When investigated I see the Secondary database no permission or privileges as in Primary. Why? How to make Secondary connectable?
SQL Server: I have Always On setup. I get secondary database connection failure. When investigated I see the Secondary database no permission or privileges as in Primary. Why? How to make Secondary connectable?
In particular sys.dm_db_index_physical_stats for fragmentation collection.