We've used Log Shipping for almost 5 years now for our DR server. It works very well, but it has its quirks and it takes us at least 20 minutes to perform a failover. Also, if it gets out of synch on a big database plan on spending an entire day or more getting it synched back up. If you want I have some detailed docs on how to set this up and perform role reversals and failovers.
I hope to use transactional replication to feed our reporting server some day down the road. Remedy supports this starting with version 7, but I'm on 6.3. Currently I use DSO to feed my reporting server but it has a lot of overhead and poor performance at times. I strictly do independent copies so I don't need ownership chains. With transactional replication I could copy the data every time it changes on the tables I want without all the processing on the app server. But I wouldn't use replication as a DR solution, I'd stick with log shipping. If you have SQL 2005 I'd look at database mirroring. That's what we're moving to pretty soon. Its a lot like log shipping only failovers are much quicker and more automated. Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of jmchugh Sent: Friday, January 25, 2008 4:25 AM To: [email protected] Subject: Pros and Cons of using different replication methods for failover/disaster recovery Hi All, Environment: ARS 7.0.x Windows 2003 ITSM 7.0.x Mid-Tier 7.0.x All on the same server. On an MS SQL Server 2000 or 2005, what are the pros and cons of using the following Replication methods for failover/disaster recover o Log Shipping o Snapshot Replication - may not cope with full recovery because it's a 'snapshot' in time, but .... o Transactional Replication - is this too hard on the servers/ network? o Merge Replication - this requires primary keys and Remedy doesn't have any .... Is this a correct assumption? Any help is appreciated ... Thanks John ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. **************************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
