I haven't tried it with Remedy but from what I picked up in a 2005 class a snapshot may work a bit better. From the labs we did in class seem to make a pretty clean copy of the db but I haven't messed with it in the real world yet.
Jason On Fri, Jun 6, 2008 at 7:57 AM, Moore, Christopher Allen < [EMAIL PROTECTED]> wrote: > ** > > Phil- > > > > Thanks for the reply. I he did use transactional, which seems like it > should not have caused problems, and the BMC tech we talked to said it was > supported. > > > > Once he put it on the dev side, everything appeared to be fine until form > changes occurred- if you have anyone looking to use it I'd definitely > suggest testing it on a test/dev install and doing form changes both in the > admin tool and the class manager to make sure things are acting like they > should. > > > > Chris > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Phil Murnane > *Sent:* Friday, June 06, 2008 9:29 AM > *To:* [email protected] > *Subject:* Re: Cautionary tale? SQL Replication service and Remedy > > > > Chris: > > > > What kind of "replication" did your DBA set up? We have a customer looking > at this type of configuration in order to create a reporting server. > They're deciding between either transactional replication with a read-only > consumer or a mirrored database with snapshots. > > > > BTW, we did some testing a few years ago with SQL Server 2000 and > transactional replication with read-write consumers, and that failed > miserably because SQL Server added columns to every table to be replicated, > which of cource confused arserver.exe terribly. > > > > Thanks, > > --Phil > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html_____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"
