Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2010-11-29 : 10:25:23
|
| Hi,I am planning to install SP2 for SQL Server 2008 on a server that has a couple of mirrored databases (High Safety - no witness). I have a couple of questions that I hope someone can clarify first:1. If I upgrade the Principal do I have to also upgrade the mirror? Ideally I would like to only upgrade the principal as there is an app that hooks into the databases. If SP2 causes issues I intend to point the app at the mirrored (non SP2 db's). If all appears well a day or so after the upgrade I will upgrade the mirror also.2. When running the SP2 upgrade should I disable mirroring?Any advice would be appreciated. |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2010-11-30 : 11:44:18
|
| Upgrade complete, here are my answers to my questions:1. No. I have upgraded only the Principal instance and the mirrored instance seems quite happy to carry on mirroring.2. I did in this instance but I don't think it is required. |
 |
|
|
|
|
|
Install SP2 on server with mirrored databases