The 5th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are facing severe issues with their environment, they can plan to test CU5 in … Continue reading →

The 15th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 15 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are facing severe issues with their environment, they can plan to test CU15 in … Continue reading →

The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe issues with their environment, they can plan to test CU7 in test environment … Continue reading →

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%\Cluster folder on each node in the cluster and the name of the file is CLUSTER.LOG. In Windows 2008, One of the major change is cluster logs logging. … Continue reading →

Steps to restore SQL Server Master Database :- 1) Stop SQL Server Services 2) Add [-m] startup parameter in SQL Services from configuration manager Parameter [-m] Starts SQL Server instance in single-user mode. SQL Server in single-user mode can connect with single user only and did not start CHECKPOINT process. Starting SQL Server in single-user … Continue reading →