SYMPTOM Service Pack 4 for SQL Server Database Services 2005 ENU (KB2463332)’ could not be installed. ERROR ———————————————————————————————— Product : Database Services (MSSQLSERVER) Product Version…
Question After connecting to SQL Server using SQL Server Management Studio, I am not able to see the green play arrow on the SQL Server…
At first I thought starting SQL Server in Single user mode is easy in Windows 2008 fail-over cluster. But I was wrong, If I just…
Why do we need this? By default, you might be having the stock media package which will give you a SQL server without the latest…
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…