Category Archives: SQL Server

ISSUE : Today, My Friend is facing issue with SQL Server error logs on one of my production server. SQL Server is not able to read SQL server error log files. We have checked that SQL Server Error log files are accessible on file system. 1) When we are running SP_readerrorlog, XP_readerrorlogs or XP_enumerrorlogs, query … Continue reading →

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

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 →