Here are the steps I documented when we moved our DB from one SQL Cluster to a different SQL Cluster.
Remedy v Shut down ARS Service v Copy ARSystem DB o Verify permissions / owner is ARAdmin & password v Change Sybase_Server_Name in AR.CFG o Program Files\AR System\Server Name\Conf v Start ARS Service RKM v Shut down Tomcat Service v Copy RKM DB v Copy RKMAdmin user id v Change URL of JDBC:SQLSERVER in KMS_Config.xml o Program Files\AR System Applications\BMC Remedy Knowledge Management\data\kms_config v Start Tomcat Service From: Ramagiri <mailto:ravi.ramag...@gssamerica.com> Sent: Thursday, December 17, 2009 2:26 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Separation of DB and Application server ** Hi , Right now we have application and the DB server in one server . We would like to separate DB to different server, what kind of precautions and preliminary steps need to take care to do this task.Please need all your help. Details:- ARSystem7.1+ITSM7.0.03+Windows Enterprise 2003 with SP2 + Sql Server 2005+ Apache Tomcat as webserver. ________________________________________________________________ RAVI CHANDRA . RAMAGIRI Infrastructure Management Services Team System Administrator - Windows / Remedy (O) +91 40 44556600 (351) (C) +91 9985794493 (V) 847-879-4995 Ext:- 351 * ravi.ramag...@gssamerica.com <mailto:rambabu.ru...@gssamerica.com> GSS America InfoTech Ltd., A SEI-CMMI Level 3 certified company Third Floor, Block 'B', Cyber Gateway, HITEC City, Hyderabad - 500 081. AP. India www.gssamerica.com <http://www.gssamerica.com/> P Please do not print this email unless it is absolutely necessary. Spread environmental awareness. Disclaimer This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. __________ Information from ESET NOD32 Antivirus, version of virus signature database 4694 (20091216) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"