Problem solve

SQL Server Replication

• Splitting SQL Server backups to multiple files

  Splitting database backups helps save space and run your SQL Server backups more efficiently. Get tips for executing this from Ashish Kumar Mehta. Continue Reading

• Coding for seamless SQL Server database mirroring

  SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring. Continue Reading

• Compare and synchronize databases with SQL Compare

  Do you frequently need to compare or synchronize your databases? Read this tip by SQL Server expert Roman Rehak to learn the secrets of effective database synchronization using SQL Compare. Continue Reading

• SQL Server merge replication using IIS

  In older versions of SQL Server, securely replicating data between sites or companies was not easy to do. Microsoft SQL Server merge replication simplifies the process using Internet Information Services (IIS). Continue Reading

• SQL Server replication: How it works and when to say no

  Each form of SQL Server replication offers its own benefits, but sometimes the best option is to avoid replication altogether. Continue Reading

• Push vs. pull: Configuring SQL Server replication

  Learn the difference between push and pull subscriptions and how to determine the best placement for SQL Server replication's Distribution Agent.Continue Reading

• Top load balancing methods for SQL Server

  There are a number of way to achieve load distribution in SQL Server environments. Learn about some of the key methods, including merge replication, log shipping and SSAS server farm deployment.Continue Reading

• New replication features in SQL Server 2008 and what they mean to you

  SQL Server 2008 features several replication improvements, and some are more compelling than others. Here you'll learn what's new with snapshot delivery, peer-to-peer topologies, merge replication and more.Continue Reading

• SQL Server database replication tutorial

  SQL Server replication involves some decision making on the part of the DBA. What's the best method for your SQL Server environment -- snapshot, merge or transactional replication? Are there any areas where you can expect to be tripped up? SQL ...Continue Reading

• Licensing a standby server for SQL Server replication

  Is a license needed for a standby server if it's used for SQL Server replication? Get that answer and a comparison of SQL Server log shipping to replication.Continue Reading

• Upgrade live applications to SQL Server 2005 for high availability

  Part four in this series takes you through the stages of maintaining live applications. Find out how to push live data from one cluster to another using a conversion database and replication techniques.Continue Reading

• Tool to synchronize two SQL Server databases

  Discover a tool that synchronizes two SQL Server databases allowing changes to one SQL Server database to update on the other.Continue Reading

• Database Snapshots: Creating read-only copies of a database

  Database Snapshots feature in SQL Server 2005 Enterprise Edition creates read-only files. For these separate databases, our site expert Adam Machanic explains the functioning of locks.Continue Reading

• Merge replication pros and cons in SQL Server 2000

  Merge replication should typically be avoided when achieving high availability in SQL Server 2000, according to contributor Michelle Gutzait. She explains the pros and cons of using application load balancing with merge replication and offers a ...Continue Reading

• Ten merge replication tips and tricks

  From schema and parameter changes to wrapping and limiting merge agents, SQL Server MVP Hilary Cotter offers various tricks to help you get the best performance from your merge replication efforts.Continue Reading