[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

The sequence on patching the SQL server mirroring parnter with witness

Dear all,

please suggest the patching sequence of SQL server mirror partner with witness.
0
marrowyung
Asked:
marrowyung
  • 5
  • 2
1 Solution
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hi,

Hope the below article link will be helpful to you

http://www.mssqltips.com/sqlservertip/2701/steps-to-apply-a-service-pack-or-patch-to-mirrored-sql-server-databases/


Hope you will get something out of it
0
 
marrowyungAuthor Commented:
I think there are problems by that links:

"Step 5
Once the patch is complete, reboot the "Mirror" server."

the mirror server shouldn't not need reboot as we only patch the SQL server, right? except something has been lock during the pattching process but SQL upgrade Wizard will tell you this.

"Step 6 (optional)
If your database mirroring is set to asynchronous (High Performance mode), we will need to synchronize the databases first. To do this we will need to issue the following statement for every database on the "Principal" server that is mirrored. "

what if my mode is synchronous mode ? any diff?
0
 
marrowyungAuthor Commented:
how about the witness server? only upgrade that as the last step ?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
Vikas GargBusiness Intelligence DeveloperCommented:
If mode is synchronous  then Step 6 is not required.
0
 
marrowyungAuthor Commented:
tks, how about the witness server? only upgrade that as the last step ?
0
 
marrowyungAuthor Commented:
it should be the last one ?
0
 
marrowyungAuthor Commented:
if I am also asking when to patch the mirror witness and you didn't answer on that part, I am very happy on this.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now