Yearly Archives: 2015

The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 6 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 CU6 in … Continue reading →

Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for download at the Microsoft Support site. SQL Server 2014 Service Pack 1 (SP1) contains all the hotfixes released since the initial release of SQL Server 2014 RTM. I suggest to test SQL Server 2014 Service … Continue reading →

Steps of Moving MSDB & Model SQL Server system Database to new locaation:- 1) Check current location of MSDB & Model Databases by executing below query SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id in (DB_ID(‘MODEL’),DB_ID(‘MSDB’)); You can also use “Execc SP_HelpDB ‘<DBNAME>’” for these details. 2) Execute Alter Database command with mofigy … Continue reading →

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 →