January 27, 2009 at 11:28 am
Hi,
I'm newby on administering log shipping, and I have to apply the SP4 on my 2 SQL2000 servers.
All servers are production servers, so, I'm not abble to test the upgrade ...
- The first has the primary database
- The second has the standby/read_only database
How may I proceed to install the SP4 (the Micosoft documention about that isn't very easy to understand ...) :
- Have I to stop all log shipping jobs ? (copy, load, check ...)
- which server has to be the first patched ?
- What about the standby/read_only database ? One the secondary server will be updated, this read_only database won't, isn't it ? Have I to break and rebuilld the log shipping ?
Please, could you help me ?
Thank you in advance
JM
January 27, 2009 at 12:18 pm
log shipping is not sensitive to service packs, you wont need to break it and re-install.
apply the service pack to the primary first, no technical reason for this, but it means if the live application does hit problems you can fail over to the standby whilst you back out the service pack (which means an uninstall\reinstall).
The upgrade does not affect user databases so no changes will be copied across by log-shipping.
procedure -
disable log shipping jobs
back up all databases
run the service pack (just double click the file)
reboot server if required
backup system databases again.
re-enable log shipping jobs
test.
One trick that might save you hassle if you have to back out is to stop SQL before the upgrade and copy the system database files (except tempdb) off somewhere else. Then you can just move these files back to their original location if you have to reinstall up to original version, and quickly get your configuration back. Copy them again after the upgrade for use in emergencies.
make sure the account you run the upgrade under has admin privileges.
---------------------------------------------------------------------
January 29, 2009 at 12:39 am
Hi George,
thank you very much for your answer, and for your advices !
JM
February 10, 2009 at 6:28 am
It worked very well.
Thank's again 🙂
February 10, 2009 at 6:30 am
thats good to hear. thanks for the feedback.
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply