Keeping updated production environment is an important task for any DBA. Updated Database Server allows to Secured and bug free environment and it helps to keep growing organization and there business process. To updated our production environment we should know few terms related to Database server maintenance activity.
Security Patch – Publicly released update to fix a known bug/issue in SQL Server Version.
Security Patch – Publicly released update to fix a known bug/issue in SQL Server Version.
Hotfix –A hotfix is a single, cumulative package that
includes one or more files that are used to address a problem in SQL Server.
Service Pack –A service pack is a collection of updates,
fixes and/or upgrade to a SQL Server. Installing a service pack is easier and
less error-prone than installing a high number of patches individually, even
more so when updating multiple computers over a network.
Community Discuss :Last Month a question raised on SQLServergeek's Group by permalink .How many of you DBA 's.apply CU's. As part of upto date upgrade patching sqlserver? Do we really need to apply them on prod?
Responses :
Vijay Rodrigues : It's recommended to test fixes before applying them in production...
Venkat Yadav : Dependents on the Environment & requirement from the customer, Yes , it's advisable to update the sql with latest CU's if possible but make sure you test them in non- prod environment and its compatible with the applications that are being hosted.
We can download these from Microsoft and sqlblog .Brenozar' Blog is more clear for CU(Cumulative Updates) on SQL Server 2012.
We can download these from Microsoft and sqlblog .Brenozar' Blog is more clear for CU(Cumulative Updates) on SQL Server 2012.
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757