You are exploring high availability and disaster recovery options and want to know more about SQL Server Availability Groups. What are some of the Frequently Asked Questions about SQL Server Availability Groups?
Please read the latest MSSQLTips post: “SQL Server Availability Groups: Your FAQs Answered“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
During our regular security reviews we have discovered that one of the SQL Servers with Availability Groups has an individual DBA’s login in addition to the DBA group as a member of the sysadmin server role. The DBA is already a member of the DBA Domain group, so we are not sure why we had this login on SQL Server.
We have tried to remove the login, but couldn’t remove it.
In this tip we will be providing troubleshooting steps required for the Drop Login issues.
Please read the latest MSSQLTips post: “Drop Login issues for logins tied to SQL Server Availability Groups“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
This tip is again on my favorite topic – Policy Based Management.
Please read the latest MSSQL Tip: “Using Policy Based Management for SQL Server Availability Groups Data Loss Alerts“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.