March 13, 2012 at 3:59 pm
You should be fine updating the subscriber (reporting instance) and leaving the publisher (live) alone. You are running a newer build on the reporting instance already so that makes it a more comfortable move.
I would recommend applying SQL 2005 SP4, then the latest post-SP4 cumulative update, CU3, plus any other post-CU3 hotfixes and QFEs you think you need to address open issues:
The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 4 was released
If memory serves, SP4 cannot be uninstalled so make sure you have backups and all binaries to get back to the current build before getting started.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 14, 2012 at 6:30 am
Thank you 🙂
Regards
ld
Stoke-on-Trent
United Kingdom
If at first you don't succeed, go to the pub and drink away your current thought plan.
March 14, 2012 at 9:00 am
You're welcome 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply