November 30, 2011 at 9:10 pm
Hi my name is Ryan, I have some questions regarding upgrading to SQL Server 2008 R2. I have a production server using MS Window Server 2003 R2 and SQL Server 2008. The Question I want to ask is, if I upgrade my SQL Server in my production server to SQL Server 2008 R2, what will happen to my already made Jobs and maintenance plan. will it be malfunction or even erased because of the upgrading process ? I need some advice on this.
Thanks in advance 🙂
November 30, 2011 at 10:50 pm
they will be upgraded.
November 30, 2011 at 11:18 pm
ryan.reinaldi (11/30/2011)
Hi my name is Ryan, I have some questions regarding upgrading to SQL Server 2008 R2. I have a production server using MS Window Server 2003 R2 and SQL Server 2008. The Question I want to ask is, if I upgrade my SQL Server in my production server to SQL Server 2008 R2, what will happen to my already made Jobs and maintenance plan. will it be malfunction or even erased because of the upgrading process ? I need some advice on this.Thanks in advance 🙂
Dont worry about them, they will be upgraded. If you can provide the details about your upgrade strategy then we can answer it better.
November 30, 2011 at 11:20 pm
Hi Sujeet thanks for the reply, I think my upgrade strategies will be an In-Place Upgrade, so what will happen if do that kind of strategy.
Thanks 🙂
December 1, 2011 at 12:21 am
ryan.reinaldi (11/30/2011)
Hi Sujeet thanks for the reply, I think my upgrade strategies will be an In-Place Upgrade, so what will happen if do that kind of strategy.Thanks 🙂
In-place upgrade is least recommonded strategy by Microsoft. If any how the upgrade process fails in between, then you would have to do the re-installation from scratch (i.e. reinstalling the windows & then reinstalling the SQL Server), so that way you need plenty of downtime.
You can download the document provided by Microsft for easy upgrade process.
(Download the docx from first link)
December 2, 2011 at 12:05 am
Hi Sujeet thanks again for the reply, I'll check your web link that you gave me later on. By the way I Installed upgrade advisor in my production server and i ran the upgrade advisor wizard, and the result was a bit tricky I believe. One of the component which was Reporting Services gave me this error result
"Upgrade Advisor detected one or more custom data processing extensions on the report server. Upgrade can continue, but you must move the data processing extension assemblies to the new installation folder."
Do you know what it means ? Does that results mean I cannot do the upgrade ?
Thanks in advance 🙂
December 2, 2011 at 12:24 am
You can continue your upgrade.
There is a discussion on the http://social.technet.microsoft.com/Forums/en-US/operationsmanagerdeployment/thread/f661b759-38cb-4256-8d0c-4af0d13e9cf0/
As per that need to go for CU4.
As its in place upgrade make sure you have proper backups for all user databases and sys databases in place.
December 2, 2011 at 12:38 am
Hi Pradyothana, thanks for the reply. about the link I'll look into it. And about the CU4 (Cumulative Update), what will happen if I don't install it, is there any fatal error in the upgrade process or the upgrade will worked but I couldn't use the new Reporting Services, what will it be ?
Thanks in advance 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply