-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Microsoft SQL Server 2008 R2 Administration Cookbook
By :
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 Objects (RMO) concepts or by obtaining information using TSQL statements.
In this recipe, we will work on TSQL methods to manage the SQL Server replication process. Using TSQL methods, gives you more control over the underlying objects generated...
Change the font size
Change margin width
Change background colour