June 4, 2012 at 12:00 pm
I'm performing SQL 2008 Standard Edition upgrade to SQL 2008 Enterprise Edition on an Active/Active Cluster. I've extensively researched pre-upgrade and post-upgrade tasks, however I couldn't find answers to the following questions. Hopefully this great community can help!
Node A & Node B
SQL01 - Clustered SQL Instance; Node A home node; Node B Passive
SQL02 - Clustered SQL Instance; Noda B home node; Node A Passive
SSAS01 - Clustered Analysis Services instance; Node A active home node; Node B Passive
SSIS - Installed as local instance on each Node.
Questions
1. Will SSAS01 (Analysis Services instance) be included in SQL01 upgrade as a feature OR will it require running its own individual upgrade?
2. Does an edition upgrade touch user databases? We have several read-only user db's and need to know if I should change them to read-write before running upgrade process.
Thanks in advance!!!
June 4, 2012 at 12:39 pm
Can't answer your first question, but the answer to your second is probably. Iknow it is necessary when changing versions (2005 -> 2008 for instance). Not too sure about just an edition change. If you have a sandbox server, you could test it there first.
June 5, 2012 at 5:40 am
I'm getting two VM's today to setup SQL 2008 Standard Ed cluster and test edition change to Enterprise. Will post answers after testing.
June 6, 2012 at 1:26 am
yesterday I did an edition upgrade from SQL 2008 R2 Standard to SQL 2008 R2 Enterprise.
User databases are not affected. Even master database is not affected.
We have our windows files + sql binaries installed on a mirrored disk.
Data files are on a SAN drive.
- We broke the mirror
- Upgrade edition (really fast < 1 min)
- Put back the old mirror (so rollbacking)
- Edition was back Standard Edition. No need to put back backups of master db or user db's.
Kind Regards
Geoffrey
June 7, 2012 at 10:54 am
Thanks for the info Geoffrey! We had VM provisioning issue so I just got my test cluster and am installed SQL 2008 Standard now. Hopefully it's as smooth as you say. Well, I expect it to be quick and easy. I'll post back if anything interesting occurrs.
Jared :w00t:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply