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 ??
I took the full backup of production database (
.bak), msdb database (
msdb.bak), ssas cube databases (
.abf), report server (
ReportServerTempDB.bak, Encryption key backup.*
I had disabled automatic security updates.