Category Archives: SQL Server

Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure, store procedure etc.) Answer : Yes. So here we explian how :- Databse snapshot is read only databse. It’s a static view database on which only read only operaton can be performed. Database snapshot … Continue reading →

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 →