Replicating SQL Server over the Internet, part 2

Replicating SQL Server over the Internet, part 2

Continued from part 1...

    Requires Free Membership to View

    Login

    When you register, you’ll also receive targeted emails from my team of award-winning editorial writers.  Our goal is to keep you informed on the hottest topics and biggest challenges faced by today's SQL Server database pros.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

To address your security concern while replicating data on different sides of a firewall, it is advantageous to follow the best practices for securing your SQL Servers. For SQL Server security recommendations visit Enterprise SQL Server Auditing and Security Best Practices. This URL is to a recent presentation delivered at the SQL PASS 2003 Community Summit and should serve as a solid foundation. It is also beneficial to work with the ISP and your security department to explore encryption and network security options to properly protect your organization's most valuable asset.

With Yukon, the next release of SQL Server, high availability will be improved with the introduction of database mirroring while being able to continue to leverage the existing SQL Server 2000 features. Database mirroring is very similar to log shipping except with a very short amount of latency between the principal and mirror database which are purportedly managed by a witness. With this technology the two data sets will operate independently with near real-time database transaction log entries passed between the principal and the mirror with the ability to failover in an automated manner within three seconds. This new technology from Microsoft for SQL Server will solve a near real-time data availability need with two independent data sets. For more information visit An Overview of SQL Server Yukon for the DBA.

For More Information

This was first published in February 2004

Back to top