Troubleshooting SQL Server 2017 Roles If you have problems with SQL Server 2017 roles, review this troubleshooting checklist to find potential solutions. 1. The error 920 may occur when you modify the database script level. This error indicates that only members of the sysadmin role can modify the database script level. To resolve this problem, ensure that user, who modify...
Tag: public
SQL Server 2012 Clustering Optimization Tips
SQL Server 2012 Clustering Optimization Tips You can use cross-cluster migration of AlwaysOn Availability Groups for OS upgrade. SQL Server 2012 service pack 1 introduces support for cross-cluster migration of AlwaysOn Availability Groups for deployments to a new Windows Server Failover Clustering cluster. A cross-cluster migration moves one AlwaysOn availability group to the new destination Windows Server Failover Clustering cluster...