Yearly Archives: 2015

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 →

The Resource database is a read-only database that contains all the system objects. This DB included with SQL Server 2005 to increase security of system metadata. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does … Continue reading →