Good move.. Never host the DB Server on the same box as the Application Server...
Apart from maintaining the same database name, database user name and password, all you need to do is point to the remote DB once you set it up on a remote machine by editing the ar.cfg file.. Obviously in order to do this you would need to restart the AR System server so it has to be done when the least users are connected to it, after informing them of a expected short outage. The outage should last no more than an hour or so, depending on the size of the DB that you would need to backup and restore to a remote instance.. If the DB is using windows authentication, make sure you replicate that correctly on the remote instance, else authentication to the DB will fail.. Joe From: Ramagiri Sent: Thursday, December 17, 2009 2:26 AM Newsgroups: public.remedy.arsystem.general To: [email protected] 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 * [email protected] 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 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: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
