In case you are trying to install a SQL Server 2008 R2 service pack in a clustered SQL Server environment and the installation fails reporting something similar to the below: Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the…
Saving maintenance plan failed
If you encounter the above error message when trying to save a maintenance plan you created using the the wizard in SQL Server 2005 Management Studio (SSMS), the first (obvious) thing you should try, is to check if the latest service pack is installed and if it is not then…
SQL Server 2008 Service Pack 1
SQL Server 2008 Service Pack 1 was just released yesterday (April 7, 2009). Along with the fixes for known bugs, this Service Pack also adds some new functionality to SQL Server 2008 mainly from the DBA’s perspective. What’s new————-Microsoft has added new functionality to SQL Server with this service pack.…
SQL Server 2005 Service Packs
Last night I installed Microsoft BizTalk Server 2006 R2. Though, during the configuration process of BizTalk, I was prompt that SQL Server 2005 Service Packs were not detected. At that time I though to myself; how do I find if any, and which Service Pack is installed for SQL Server?…