Hi, we had many problems with database-replication as well (one point was that we lost data after we modified forms with ARAdmin). We are using the DB-copy for Reporting issues only, so we moved over to simple Logshipping instead. This method of replicating a DB does not influence the source in any case (no modification of tables necessary, ...). The destination is read-only.
Regards Michael 2008/10/17 Jiri Pospisil <[EMAIL PROTECTED]> > ** > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Please Read The Disclaimer At The Bottom Of This Email > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > > HI, > > > > We have DB replication enabled on SQL2005 and it has to be turned off > before making any changes to forms in Remedy. > > Moving a field may result in the Remedy trying to rebuild the SQL view > representing the form, which in case of Remedy constitutes dropping the view > and re-creating it. Dropping objects that are being replicated is not > possible if they are being replicated and that is most likely the reason for > errors you are getting. > > You can always turn the SQL logging off or check error logs to see what > error exactly you are getting. > > > > Regards > > Jiri Pospisil > > IT Services > LCH.Clearnet > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Nall, Roger > *Sent:* 16 October 2008 19:21 > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Replication > > > > ** > > Brandi, > > > > We have been using SQL replication for several years. While I am not a DBA > here is what I can remember: > > - Tables created by Remedy in ARSYSTEM really does not declare C1 as a > primary key (at least in SQL 2000). > - I believe this is done manually by the DBA. > - When a table is being replicated you cannot Alter the ARSystem table > without dropping replication first. Moving a field does not constitute an > Alter of the table. > - Joe is correct in that ARADMIN must be the dbo of the replicated db. > > > > HTH, > > > > Roger A. Nall > Manager, OSSNMS Remedy > T-Mobile, USA > Desk:972-464-3712 NEW > > Cell: 973-652-6723 > FAX: > sf49fanv AIM IM > RogerNall Yahoo IM > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Joe DeSouza > *Sent:* Thursday, October 16, 2008 12:31 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Replication > > > > Brandi, > > I have replicated databases on MS-SQL, Oracle and other databases > successfully and not have Remedy throw up on the users.. > > What method of replication did the dba use? > > Does the ARAdmin user that owns the ARSystem database have the same rights > and privileges as the ARAdmin user on the original database? Typically on > MS-SQL the ARAdmin user should be the dbo of the ARSystem database. > > Joe > > > > ----- Original Message ---- > From: Brandi Barbour <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Thursday, October 16, 2008 1:11:25 PM > Subject: Replication > > ** > All, > We have windows 2003 with sql 2005, ARS 7.1.0, ITSM 7.0.3. Our database > engineer set up SQL replication for our production sql server to our backup > sql server. The problem is that when he does the SQL replication set up the > remedy system does not agree with it. We get errors when someone modifies a > request and it pushes a value to a char field with an attached menu with the > pattern = $MENU$. It says that the value we are sending does not meet > $MENU$. We also get errors if we go to the admin tool and try to move a > field.. Errors concerning the sql view does not exist. It seems that > somehow the views are being changed. I know someone on the list had said > that the replication adds columns to the views so the system is not > recognizing the views correctly. I have seen some questions on arslist but > did not know if anyone had a solution as of yet. > Has anyone successfully set up SQL replication successfully? > Thanks, > Brandi > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" html___ > > > ************************************************************************************************* > > > > This email is intended for the named recipient(s) only. Its contents are > confidential and may only be retained by the named recipient(s) and may only > be copied or disclosed with the consent of LCH.Clearnet Limited. If you are > not an intended recipient please delete this e-mail and notify > [EMAIL PROTECTED] > > > > The contents of this email are subject to contract in all cases, and > LCH.Clearnet Limited makes no contractual commitment save where confirmed by > hard copy. LCH.Clearnet Limited accepts no liability, including liability > for negligence, in respect of any statement in this email. > > > > LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High > Street, London EC3N 1EA. Recognised as a Clearing House under the Financial > Services & Markets Act 2000. Reg in England No.25932 > > Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com > > > > > ************************************************************************************************* > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"