We are currently using Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) as our production data warehouse database.
I need to apply hotfix / security patch version 10.50.2550.0 to our production data warehouse.
Can anybody please tell me can I directly apply this hotfix to my production server ??
I am new to database admin domain.
If I can directly apply the hot fix to production server then what are the precautionary steps that I have to take.
Shall I have to restart the production server compulsorily during off-peak hours ??
Note:
I took the full backup of production database (
.bak
), msdb database (msdb.bak
), ssas cube databases (.abf
), report server (ReportServer.bak
),ReportServerTempDB.bak
, Encryption key backup.*I had disabled automatic security updates.