SQL Server redundancy over a WAN connection

cnc__guy

cnc__guy

Well Known Member
MS SQL Server 2008 R2 64-bit

How do most of you handle redundancy over a WAN connection.

I am curious about Mirroring, Clustering and/or other methods of replication?

Interested in experiences with both automatic and manual failover?

Do you use MS SQL only or third-party products?

Just overall looking for ways that the JDE community has implemented this capability.

Thanks,
James
 
I have always been a fan of SQL log shipping. Native or using a third party tool, it is rock solid.

I have implemented it at several customers. PM me and I can send you some jde implementation details.
 
Jeremy - I too will be in a similar situation very shortly. We are in our final stages of getting the approvals of taking out the AS/400 and replacing with Windows / SQL installation - anything you can send along will be greatly appreciated.

Regards,
CNCJay
 
Back
Top