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 |
|
thotvedt
Starting Member
5 Posts |
 Posted - 2011-03-17 : 11:38:40
|
| I have two questions. An answer to either one will help me.1. Is there an upgrade path to get from SQL 2008 SP2 to 2008 R2? OR2. Can I run a mirror configuration with SP2 as the primary and R2 (with dual instances) as the secondary and the witness? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-17 : 11:56:40
|
| Yes to both. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-17 : 13:13:14
|
| 1) You can upgrade from any version of SQL 2008 to SQL 2008 R2, you will need to purchase an R2 license as it is a separate version of the product.2) You can, but it's not supported in other than an upgrade scenario. It's not something that you would use as a permanent setup. It can only be done with SQL 2008 as the primary and 2008 R2 as the mirror, you can't fail over and still have a working mirror setup.--Gail ShawSQL Server MVP |
|
|
|
thotvedt
Starting Member
5 Posts |
Posted - 2011-03-17 : 15:33:08
|
| So can I simply use the full R2 media to upgrade the 2008 SP2 default instance? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-17 : 17:53:53
|
| Yes. It's just like installing SQL 2008 when there's an existing SQL 2005 instance.--Gail ShawSQL Server MVP |
|
|
|
thotvedt
Starting Member
5 Posts |
Posted - 2011-03-23 : 12:05:40
|
| Will this process require downtime on a live database? Or will it simply be a reboot? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-23 : 13:37:23
|
| It's like upgrading from 2005 to 2008. During the entire installation, SQL is stopped or in a state that will not allow connections--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SP2 vs. R2