Rafael, We're going through the same process now. We recently upgraded our development and test servers w/o issue, and plan to do the same on production late this month. No reinstall of the ARSystem is needed. Like anything else, it is strongly advised to perform a complete backup of your system in the event something goes wrong. And if you can perform the upgrade in a lab environment, this will give you a good idea of how long your outage time will be. Based on what we've seen, we're budgeting about a two-hour outage of our production server. Your mileage may vary.
Joe Joseph Kasell Senior Systems Engineer Navy Federal Credit Union "Rodriguez, Rafael J x23718" <Rafael.Rodriguez To @BROADRIDGE.COM> arslist@ARSLIST.ORG Sent by: "Action cc Request System discussion list Subject (ARSList)" Re: Upgrading to SQL 2005 <arsl...@arslist. ORG> 04/06/2009 06:23 PM Please respond to arsl...@arslist.o RG This is a multi-part message in MIME format. ------_=_NextPart_001_01C9B706.5E70670E Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C9B706.5E70670E" ------_=_NextPart_002_01C9B706.5E70670E Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thanks, I did not think so either but just wanted to see if anyone had any issues after upgrading. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, April 06, 2009 9:06 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrading to SQL 2005 **=20 Rafael, We are actually undergoing that upgrade at the moment without issue. Remedy doesn't seem to notice a change at all... ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718 Sent: Saturday, April 04, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Upgrading to SQL 2005 **=20 Hello, just wanted to see if any has encountered any issues upgrading the backend SQL server from SQL 2000 to SQL 2005? =20 My environment is: ARS 7.0.1 Patch 6 in a server group environment. WIN 2003 Server Remote SQL 2000 Clustered Servers =20 Also, does remedy need to be re-installed after the upgrade? =20 Thanks in advance! =20 Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial Solutions 2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p =20 =20 This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the=20 message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___=20 This message and any attachments are intended only for the use of the add= ressee and may contain information that is privileged and confidential. If the reade= r of the = message is not the intended recipient or an authorized representative of = the intended recipient, you are hereby notified that any dissemination of thi= s communication is strictly prohibited. If you have received this communica= tion in error, please notify us immediately by e-mail and delete the message and = any attachments from your system. =0D _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ------_=_NextPart_002_01C9B706.5E70670E Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Dus-ascii" = http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18372"></HEAD> <BODY> <DIV dir=3Dltr align=3Dleft><SPAN class=3D796492322-06042009><FONT = color=3D#0000ff=20 size=3D2 face=3DArial>Thanks, I did not think so either but just wanted = to see if=20 anyone had any issues after upgrading.</FONT></SPAN></DIV><BR> <DIV dir=3Dltr lang=3Den-us class=3DOutlookMessageHeader align=3Dleft> <HR tabIndex=3D-1> <FONT size=3D2 face=3DTahoma><B>From:</B> Action Request System = discussion=20 list(ARSList) [mailto:arsl...@arslist.org] <B>On Behalf Of </B>LJ=20 Longwing<BR><B>Sent:</B> Monday, April 06, 2009 9:06 AM<BR><B>To:</B>=20 arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Upgrading to SQL=20 2005<BR></FONT><BR></DIV> <DIV></DIV>**=20 <META name=3DGENERATOR content=3D"MSHTML 6.00.6000.16809"> <DIV dir=3Dltr align=3Dleft><SPAN class=3D387160513-06042009><FONT = color=3D#0000ff=20 size=3D2 face=3DArial>Rafael,</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D387160513-06042009><FONT = color=3D#0000ff=20 size=3D2 face=3DArial>We are actually undergoing that upgrade at the = moment without=20 issue. Remedy doesn't seem to notice a change at=20 all...</FONT></SPAN></DIV><BR> <DIV dir=3Dltr lang=3Den-us class=3DOutlookMessageHeader align=3Dleft> <HR tabIndex=3D-1> <FONT size=3D2 face=3DTahoma><B>From:</B> Action Request System = discussion=20 list(ARSList) [mailto:arsl...@arslist.org] <B>On Behalf Of = </B>Rodriguez, Rafael=20 J x23718<BR><B>Sent:</B> Saturday, April 04, 2009 9:27 AM<BR><B>To:</B>=20 arslist@ARSLIST.ORG<BR><B>Subject:</B> Upgrading to SQL=20 2005<BR></FONT><BR></DIV> <DIV></DIV>**=20 <META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18372"> <DIV><FONT size=3D2 face=3DArial><SPAN class=3D843212115-04042009>Hello, = just wanted=20 to see if any has encountered any issues upgrading the backend SQL = server from=20 SQL 2000 to SQL 2005?</SPAN></FONT></DIV> <DIV><FONT size=3D2 face=3DArial><SPAN=20 class=3D843212115-04042009></SPAN></FONT> </DIV> <DIV><FONT size=3D2 face=3DArial><SPAN class=3D843212115-04042009>My = environment=20 is:</SPAN></FONT></DIV> <DIV><FONT size=3D2 face=3DArial><SPAN class=3D843212115-04042009>ARS = 7.0.1 Patch 6 in=20 a server group environment.</SPAN></FONT></DIV> <DIV><FONT size=3D2 face=3DArial><SPAN class=3D843212115-04042009>WIN = 2003=20 Server</SPAN></FONT></DIV> <DIV><FONT size=3D2 face=3DArial><SPAN class=3D843212115-04042009>Remote = SQL 2000=20 Clustered Servers</SPAN></FONT></DIV> <DIV><FONT size=3D2 face=3DArial><SPAN=20 class=3D843212115-04042009></SPAN></FONT> </DIV> <DIV><FONT size=3D2 face=3DArial><SPAN class=3D843212115-04042009>Also, = does remedy=20 need to be re-installed after the upgrade?</SPAN></FONT></DIV> <DIV><FONT size=3D2 face=3DArial><SPAN=20 class=3D843212115-04042009></SPAN></FONT> </DIV> <DIV><FONT size=3D2 face=3DArial><SPAN class=3D843212115-04042009>Thanks = in=20 advance!</SPAN></FONT></DIV> <DIV> </DIV> <P style=3D"TEXT-ALIGN: center" class=3DMsoNormal align=3Dcenter>Rafael=20 Rodriguez<B><SPAN=20 style=3D"FONT-FAMILY: Webdings; COLOR: #a8b400">|</SPAN></B>Manager=20 Remedy/Mid-Tier Enterprise<B><SPAN=20 style=3D"FONT-FAMILY: Webdings; COLOR: #a8b400">|</SPAN></B>Broadridge = Financial=20 Solutions</P> <P style=3D"TEXT-ALIGN: center" class=3DMsoNormal align=3Dcenter>2 = Journal Square=20 Plaza<B><SPAN style=3D"FONT-FAMILY: Webdings; COLOR: = #a8b400">|</SPAN></B>Jersey=20 City, NJ 07306<B><SPAN=20 style=3D"FONT-FAMILY: Webdings; COLOR: = #a8b400">|</SPAN></B> 201.714.3718 p</P> <DIV align=3Dcenter><IMG id=3DPicture_x0020_1 alt=3D"Broadridge image"=20 src=3D"cid:796492322@06042009-21FA" width=3D144 height=3D45></DIV> <DIV> </DIV><PRE>This message and any attachments are intended only = for the use of the addressee and may contain information that is privileged and confidential. If the = reader of the=20 message is not the intended recipient or an authorized representative of = the intended recipient, you are hereby notified that any dissemination of = this communication is strictly prohibited. If you have received this = communication in error, please notify us immediately by e-mail and delete the message and = any attachments from your system. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" = html___</PRE>__Platinum=20 Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ = </BODY></HTML> <pre>This message and any attachments are intended only for the use of th= e addressee and may contain information that is privileged and confidential. If the reade= r of the = message is not the intended recipient or an authorized representative of = the intended recipient, you are hereby notified that any dissemination of thi= s communication is strictly prohibited. If you have received this communica= tion in error, please notify us immediately by e-mail and delete the message and = any attachments from your system. =0D __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ------_=_NextPart_002_01C9B706.5E70670E-- ------_=_NextPart_001_01C9B706.5E70670E Content-Type: image/jpeg; name="image001.jpg" Content-Transfer-Encoding: base64 Content-ID: <796492...@06042009-21fa> Content-Description: image001.jpg Content-Location: image001.jpg /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4 +JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAAtAJADASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3 +Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3 +Pn6/9oADAMBAAIRAxEAPwD2aiiu Z8V6rrGmz2w0z7KVZW3rODknIxgjpWVarGlBzlsNK50tFcBa +NtUlnNtcItvcqN3llQQw9VPcUv/ AAnVwboWiTxyTZwQkJYKfcjgVwvM6SdrP7iuRnfUVS0e6kvNMhnlI3uCTgYHU1ervpzVSCmtmQFF FFaAFFFFABRTJJEijaSRlRFGWZjgAUkE8NzCstvKksbfdeNgyn6EUASUU0yIHCFgGIyFzyabPPDb RNNcTJDGv3nkYKo +pNAElFNjkSWNZI2DowyGByDTqACiiigArjPHWqWVhcWa3dwkRZWKhs88iuzr yb4yqX1PSEBALRuMscAfMOprmxVCNek4SdkXBXkYWoz214Y/7H1R5LpXJWPcWOCPmKk9OK0rTWtA sbZLeC9iVFGOAeT6njrXL2c9r4fk +0LNHeXf3QsXKRjv83c444pmrwJIDdWloGhlbcs8JOPoy/wt XjywcZtU5N8vR7Xf9bHRY938K3MN34ctZreQSRtuww6H5jXCeNhYy/Ei2j1OG9uLP +zwXitN5fOW wcLzXVfDX/kQtN+kn/oxqh1vw7r0vi+PXtFurGJltPs +26Vj3JJ4/CvcpwUKaguiSMFpJnNeGdfn 0Lwnr2qW0xurW2uVFpZ3MxMkKlsfP3XII49jW1N451qy0 +K8vtDjjfUHjj023WfLyM3Uv/dHT86q /wDCutTl0jWzc6jbyapq5QsyoViTD7j7/pW14g8Iz6voemQW90kGoaWY3glIJQsoAIPfBwPyq9Qb jcZYeKtUi8QLoOuaZBBeTwmW1a3mLRy4B +Ukjg8HmqKeOdXtNcsbLVtOsI0vZxDstrwSywknA3gc d6kPhHW9Y1aTVddvrWK5jtHt7RLINtjLAjeSec8msy3+HmspJoxf +x4Rpc6uTBGwecAglnbHJ46U 9Q90s6r4r1bW7XXYNG0q3l02yjkgnuZpijMdp3FRjt1//XVLQ/FN7oHhXwvYWGmpfSagkqqhk2HI c4x271fHgzxDp8urWek39ium6q7u3noxki3A5Axx3xmpbHwNqFt/wi5e5tidFMnnbS3zhmyNvH86 NQvGwyS/kHjbQP7c0m3i1NrWZ2ljuGKwKN3AHRuB +tY/iLxRrHiXwZql3b6TBHopPliaSb98cOPm 29OuP8iuv1bwzcal4x07WPNiFrbW8kMsZzvbcGHHGP4q50eBPE8Hh+88NW +pae2lyuXjkkjbzeoO 044HI680AnHRl2w8Taoz2Hh7RLG1luLfTIZppLqUooBRcBQBk9RVW2+Jd6ugS6jfafbCaS6 +yWsU cpALgfMXY9FGRz71lazpU154mtdNgFjNPpOlxRXC3MrQKzY/hdSGbjHsKsaXpyeOfDTWVpZWmlXG i3f7gwgyW8h7jnqDjk89qB2ibujeKH1/WpNB1NbVblIvPhn0268xGHQjPYjNdjDEIYkjVmYIoUFj knHqa5/w7pGq2d682o2Oh26 +XtQ6dCVctnkkkdMdq6ShGbtfQKxdd8J6N4kkhk1S2aVoVKoVkZcA 9eh9q2qKYtjkP+FW+Ev +fCT/AMCH/wAalt/hv4atHL21vcRMepS5cZ/WuqoqXFNWaK5pdytYWMOn WcdrBu8uPONzZPJz1qzRRTStsSFFFFMAooooAKKKKACiiigDN1Lw7o2ryrLqOmW11IowHljBIHpm rlraW1jbrb2lvHbwr92OJAqj8BU1FABRRRQB/9k= ------_=_NextPart_001_01C9B706.5E70670E-- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"