Archives: August 2014
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 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… Read more
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all the user sessions & stop the application but still we are facing this issue.
Further going into details, I found that… Read more
Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the reason that full-text catalog becomes offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE… Read more
Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL Server Standalone Default Instance https://mssqlfun.com/2014/06/30/rename-or-change-sql-server-standalone-default-instance/)
Refer : Rename or Change SQL Server Standalone Named Instance (https://mssqlfun.com/2014/07/29/rename-or-change-sql-server-standalone-named-instance/)
The name of the virtual server is always the… Read more