Before we start we need to make mySQL database capable of supporting unicode characters. For that we need to change the database collation or the…
Problem: We had a requirement to change the SQL Server Fail over cluster group Virtual server name. We did that change through the cluster administrator.…
Log-in to the active node. Trigger a full backup for all System and User Databases. Script out all log-ins. If there are any user databases,…
Prerequisites SQL Server 2008 Standard/Enterprise/Developer edition install Media with Service pack 2. One IP address as SQL Cluster virtual IP and host-name as SQL Cluster virtual host-name.…
The below script helps in detecting, recording and alerting when ever a change is made to sp_config or SQL server configuration settings. This will help…