MS-SQL Post Patching Steps

MS-SQL Post Patching Steps

-Verify installation from summary.txt file

-Connect to the instance and verify the patch information

select  serverproperty('productlevel')
select @@VERSION

-Restart the system

-Check that all dbs has come online
select  name,state_desc from sys.databases

Take backup of all system dbs.
--master, model, msdb, resource
backup database master to disk='master.bak'

-Verify that all dbs are consistant
dbcc checkdb(master)

-Allow the appl team/Testing team to check connectivity from appls.

-Make the instance available to the appls by enabling TCP/IP of the instance.

To check complete information:

SELECT
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel,
SERVERPROPERTY('ProductBuildType') AS ProductBuildType,
SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductMajorVersion') AS ProductMajorVersion,
SERVERPROPERTY('ProductMinorVersion') AS ProductMinorVersion,
SERVERPROPERTY('ProductBuild') AS ProductBuild
GO