O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing SQL Server Replication processes

Whenever we talk about managing SQL Server replication processes, the best practice is to configure the replication using scripts for better control, using the Replication along with other high-availability features and Dynamic Management Views to obtain a glimpse of system resource usage. In this recipe, we will look at the three processes that are important when managing the SQL Server replication environment effectively.

Scripting the replication process helps to retain the steps to install replication in case you experience a disaster recovery process. The replication script process can be achieved by using replication wizard dialog boxes from SQL Server Management Studio, by using Replication Management ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required