marrowyung
asked on
upgrading the SQL server 2005 RTM reporting service to SP2.
Dear all,
I heard that if the SQL Server 2005 RTM edition has reporting service installed, we need to do something first, right?
What it is ? backup the encryption key ?
just want to make the whole process smooth enought for the reporting service.
I heard that if the SQL Server 2005 RTM edition has reporting service installed, we need to do something first, right?
What it is ? backup the encryption key ?
just want to make the whole process smooth enought for the reporting service.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, so just backup the key and backuop the reportserver + reporttempdb, that's it ?
for a cluster upgrade, just run the hotfix.exe on the active node on SQL 2005 (in SQL 2008, we can do rolling upgrade on passive node!!) and the change will be replicate to all nodes?
for a cluster upgrade, just run the hotfix.exe on the active node on SQL 2005 (in SQL 2008, we can do rolling upgrade on passive node!!) and the change will be replicate to all nodes?
ASKER
I saw this http://msdn.microsoft.com/en-us/library/ms155814(v=sql.90).aspx, it seems that I need to:
1) Backing Up the Reporting Services Web Sites
2) Backing Up the Configuration Files
3) Backing Up Data Files
but it seem that I can't find the configuration file on the reporting server box, anyway to do the above item easlier?
DBA100.
1) Backing Up the Reporting Services Web Sites
2) Backing Up the Configuration Files
3) Backing Up Data Files
but it seem that I can't find the configuration file on the reporting server box, anyway to do the above item easlier?
DBA100.
ASKER
I tried update the reporting service and it is smooth enough
ASKER
"BTW: why not sp4?"
Yeah, just because we are running SP2 on some of the machien and the third party application are running just fine. So we are making a lot of sense that we have to make sure that the rest of the SQL server that are still running RTM to all upgrade to SP2 as it is already proof that SP2 is working fine for our apps,
We can later on, after the SP2 still give no problem after all upgrade to SP2, then SP4. But do you think there are problem on upgrade from SP2 to SP4 ?
DBA100.