Przełącznik języka
Zaproś mnie na KAWE
Jeżeli podoba Ci się strona i chcesz wspomóc projekt!
Tools
Mining
Księgowość
Płatnik
Security
CMS
Hardware
Backup
Windows Server
Uncategorised
Databases
Przydatne strony
Emulators
Poczta
PHP
Powershell
Storage Array
Active Directory
SEO
Serwis
MSSQL
DNS
Windows
Poradniki
Antivirus program
Linux
Naprawy
Windows Server
Foto
Licznik
Visitor Info
- IP: 3.145.58.90
- Browser: Unknown
- Browser Version:
- Operating System: Unknown
Who Is Online
4
Online
czwartek, 21 listopad 2024 23:39
patching SQL Server with Availability Group and Secondary Replica
Make sure you have full backups of your databases.
On the primary replica node, change the failover mode to manual
Refresh the databases and check if MSSQL reports any errors
Apply fix - CU0x service pack Perform an update for all databases until all fixes are uploaded.
After uploading patches and restarting MSSQL, check if the cluster is in good condition. P
erform an update for the Primary server.
After uploading all patches, check if the cluster is in good condition.
If there are no errors, change the switching mode from manual to automatic.
Dodaj komentarz