|
If you want to upgrade or install a patch on two separate instances that house both the principal and mirrored database, how can you go about that? If the database that is being mirrored needs to be available 24/7 and you don't have a window to go offline, what is the best means to do this? EDIT: this is with SQL Server. |
||||
|
|
|
Assuming SQL Server, you'll want to apply the patch to the mirror, then failover and apply the patch to the server that was active (and is now the mirror). This way you only have to take one outage as you only need to fail over once. If you are doing an actual version upgrade SQL 2008 to SQL 2008 R2 for example this is a little different. No matter what there will be an outage that you have to take. |
|||
|
|
|
First hit from Google gives an MS KB article Another viewpoint "How To Apply Service Packs To SQL Servers Involved In Mirroring" |
|||
|
|
