February 12, 2016 at 11:37 am
We need to upgrade a cluster named instance. SQL Server is currently 2008 SP3 Enterprise 64 bit. We want to upgrade to SQL Server 2008 R2 SP3 Enterprise. I'd go to SQL 2012 however right now that is not an option.
This would be an inplace upgrade. I'd like to take a snapshot of the server however with the cluster that is not an option. The way I see it, upgrade SQL, then install the service packs.
Is there anything I'm missing. Any other steps to include? Comments / URLs are always appreciated.
Thanks.
February 12, 2016 at 12:24 pm
bobba (2/12/2016)
We need to upgrade a cluster named instance. SQL Server is currently 2008 SP3 Enterprise 64 bit. We want to upgrade to SQL Server 2008 R2 SP3 Enterprise. I'd go to SQL 2012 however right now that is not an option.This would be an inplace upgrade. I'd like to take a snapshot of the server however with the cluster that is not an option. The way I see it, upgrade SQL, then install the service packs.
Is there anything I'm missing. Any other steps to include? Comments / URLs are always appreciated.
Thanks.
You only need the latest service pack, it has everything from the previous service packs. I may be wrong, but if the service pack is available in the directory from which you install SQL Server 2008 R2 it should be slip streamed and installed as you install R2.
February 25, 2016 at 11:30 am
Ran into one other wrinkle. While testing (and attempting to upgrade SQL), I got a error message requesting to configure ReportServer. Checking the test server, Report Server service is installed but no Report Server database, no ReportServerTempDB database. I'm assuming that means service is installed but never configured - in effect never used. I 'removed' it. Proceeded with the upgrade and it went fine.
Now that was a standalone test server. We want to upgrade a cluster named instance (2008 to 2008 R2). Same situation on the instance, Report Server service is installed but not configured. Since I'll get the same request when upgrading, my position is to 'remove' it. It can always be re-installed later if needed.
Three questions (may be overkill...):
1. Am I correct in my assumption, if ReportServer service is installed however the ReportServer databases are not there, it has not been configured or used?
2. I have not used 'Change'. Is this a better option than 'remove' (via add/remove programs) to remove the reporting service?
3. Would it be best to 'remove' from the passive node rather than active before upgrade? Does it make a differnce?
That's it. As always, comments are appreciated. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply