A Guide to SQL Server 2000 Transactional and Snapshot Replication

Installing Replication

Let me live like a sky rocket. Let me colour the night sky for a single

instant, burning with all of my being. And then burn out.

— Yukio Mishima

This chapter focuses on installing replication on your SQL Server.Most

users will only install replication on their SQL Server and then enable

Subscribers.We’ll look at these two options and then look at how to set up

your SQL Server to use a remote Distributor. After looking at these

options, we’ll look at Replication Monitor, which is the central point for

replication administration. In the process we’ll cover some of the more

advanced options and settings. Following that, for those of you who are

wizard adverse, we will look at the replication stored procedures that you

can use to carry out the same things.

There are really two parts to installing replication:

• Configuring your SQL Server as a Publisher/Distributor or a Distributor

• Configuring your Subscribers

Recall from Chapter 1 that a Distributor is a SQL Server that stores and

distributes transactions from your Publisher to your Subscriber. For most

replication solutions, your Publisher and Distributor will be on the same

server. For high throughput replication solutions, you should look at using

a remote Distributor.

Configuring your SQL Server as a Distributor

Configuring your SQL Server as a Distributor involves running a wizard

that creates a distribution database and several jobs in the msdb database.

After your distribution database is installed, you are ready to create your

publications. Let us walk through the wizards to understand how to configure

your server as a Distributor. The first time you configure your SQL

Server as a Distributor, open up Enterprise Manager (EM), connect to your

SQL server, and on the Tools menu, point to Replication, and then click

Configure Publishing, Subscribers, and Distributors (Fig. 2.1). You can

bypass this altogether and merely click Create and Manage Publications,

which is what most DBAs do. Read more

Comment on "A Guide to SQL Server 2000 Transactional and Snapshot Replication"

Home Site Map Advertise For Sale Subscribe to our Monthly Email Newsletter	Not While the Surf's Up Press A Guide to SQL Server 2000 Transactional and Snapshot Replication Installing Replication Let me live like a sky rocket. Let me colour the night sky for a single instant, burning with all of my being. And then burn out. — Yukio Mishima This chapter focuses on installing replication on your SQL Server.Most users will only install replication on their SQL Server and then enable Subscribers.We’ll look at these two options and then look at how to set up your SQL Server to use a remote Distributor. After looking at these options, we’ll look at Replication Monitor, which is the central point for replication administration. In the process we’ll cover some of the more advanced options and settings. Following that, for those of you who are wizard adverse, we will look at the replication stored procedures that you can use to carry out the same things. There are really two parts to installing replication: • Configuring your SQL Server as a Publisher/Distributor or a Distributor • Configuring your Subscribers Recall from Chapter 1 that a Distributor is a SQL Server that stores and distributes transactions from your Publisher to your Subscriber. For most replication solutions, your Publisher and Distributor will be on the same server. For high throughput replication solutions, you should look at using a remote Distributor. Configuring your SQL Server as a Distributor Configuring your SQL Server as a Distributor involves running a wizard that creates a distribution database and several jobs in the msdb database. After your distribution database is installed, you are ready to create your publications. Let us walk through the wizards to understand how to configure your server as a Distributor. The first time you configure your SQL Server as a Distributor, open up Enterprise Manager (EM), connect to your SQL server, and on the Tools menu, point to Replication, and then click Configure Publishing, Subscribers, and Distributors (Fig. 2.1). You can bypass this altogether and merely click Create and Manage Publications, which is what most DBAs do. Read more Rate This Article: Comment on "A Guide to SQL Server 2000 Transactional and Snapshot Replication" Your Name Your Comments Verification Code: 8IRAYQ Enter Code: A Guide to SQL Server 2000 Transactional and Snapshot Replication This chapter focuses on installing replication on your SQL Server.Most users will only install replication on their SQL Server and then enable Subscribers.We’ll look at these two options and then look at how to set up your SQL Server to use a remote Distributor. After looking at these options, we’ll look at Replication Monitor, which is the central point for replication administration. In the process we’ll cover some of the more advanced options and settings. Following that, for those of you who are wizard adverse, we will look at the replication stored procedures that you can use to carry out the same things. TITLES A Guide to SQL Server 2000 Transactional and Snapshot Replication DBSophic's Qure Optimizer Boosts SQL Server Performance at Logimatic JERUSALEM, January 4, 2012 /PRNewswire/ -- DBSophic, an innovative provider of performance management products for SQL Server based applications, announced the deployment of its Qure Optimizer solution at Logimatic. PlumChoice Announces Availability of Technical Service Automation Solution to Support Microsoft SQL Server BILLERICA, Mass., Dec. 22, 2011 /PRNewswire/ -- PlumChoice, Inc., a pioneer in the delivery of remote technical services in the next-generation Service 2.0 model and the parent company of Tific AB, announced today that its best-of-breed support services automation solution is now generally available for Microsoft SQL Server 2008 R2. SQL Server Magazine Reveals New Name for the Brand NEW YORK, Nov. 30, 2011 /PRNewswire/ --Penton Media technology property, SQL Server Magazine, announced today that it has changed its name to SQL Server Pro to better reflect the brand offerings. Core Services and Oracle SPARC T4 Server Deliver Client Satisfaction SOMERSET, N.J., Feb. 2, 2012 /PRNewswire/ -- Core Services Corporation ("Core Services"), an Oracle Platinum Partner and OAUG Three Star Partner, is delighted to announce Oracle Corporation's ("Oracle") recognition of Core Services as a valued partner in Oracle's SPARC T4 server success. Learn more . DBSophic's Qure Analyzer Reviewed on SQL-Server-Performance.com JERUSALEM, January 10, 2012 /PRNewswire/ -- DBSophic, an innovative provider of performance management products for SQL Server based applications, announced that the company's Qure Analyzer solution has been reviewed on . SmartFreightWare Delivers Top Application Performance with Qure Optimizer JERUSALEM, January 24, 2012 /PRNewswire/ -- DBSophic, an innovative provider of performance management products for SQL Server based applications, announced the successful deployment of its Qure Optimizer solution at SmartFreightWare. Sanbolic to Present How to Achieve SQL Server High Availability (HA) for Citrix XenDesktop WATERTOWN, Mass., Dec. 1, 2011 /PRNewswire/ -- December 14: 11:00 a.m. â€“ 11:45 a.m. Eastern TimeSanbolic Webinar: SQL High Availability (HA) for Citrix XenDesktop â€“ The Easy Way!Citrix XenDesktop 5.x requires SQL Server for the Citrix Provisioning Services (PVS) and XenDesktop databases. AgileShip Provides Enterprise Shipping Solution for Oracle EBS SCOTTSDALE, Ariz., Jan. 18, 2012 /PRNewswire/ -- Agile Network, a Gold-Level member of Oracle® Partner Network (OPN), today announced its AgileShip Shipment Management System has achieved Oracle Validated Integration (OVI) with the Oracle E-Business Suite 12.1. Sanbolic Extends Microsoft SQL Server Agility, High Availability (HA), and Scalability Across Physical, Virtualized, and Cloud Environments WATERTOWN, Mass., Nov. 14, 2011 /PRNewswire/ -- Sanbolic®, a market leader in distributed data management, today announced the launch of AppCluster version 2.0 (v2.0) â€“ a Microsoft SQL Server specific module within its Melioâ„¢ Enterprise software that extends the agility, high availability (HA), and scalability of SQL Server workloads across physical, virtualized, and cloud environments. K3 Optimizes SQL Server Performance With DBSophic's Qure Optimizer JERUSALEM, January 17, 2012 /PRNewswire/ -- DBSophic, an innovative provider of performance management products for SQL Server based applications, announced the successful deployment of its Qure Optimizer solution by K3 Business Technology Group. Qure Optimizer is the first product to implement workload tuning, a new approach to SQL Server performance optimization. Magic Software's iBOLT Integration Platform Achieves Oracle Validated Integration with Oracle's JD Edwards World OR YEHUDA, Israel, November 15, 2011 /PRNewswire/ -- Magic Software Enterprises Ltd. (NASDAQ: MGIC), a global provider of mobile and cloud-enabled application and business integration platforms, and a Gold level member of Oracle® PartnerNetwork (OPN), today announced that its iBOLT Integration Platform 3.2 has achieved Oracle Validated Integration with Oracle's JD Edwards World A9.2. iBOLT enables customers to use simple visual process definitions without requiring complex programming skills. Attunity Named Winner of Two Top Awards by SQL Server Magazine for Best Business Intelligence (BI) Software BURLINGTON, Massachusetts, November 29, 2011 /PRNewswire/ -- Attunity Ltd. (OTC BB: ATTUF.OB), a leading provider of real-time data integration software, announced today that its Attunity SQL Server-CDC for SSIS data replication software was awarded the gold medal, top honor in the "2011 Community Choice Awards", and the silver medal in the "2011 Editors' Best Awards" â”€ both in the Best BI/Reporting Tool category. Mythics Awarded Contract by the State of California for Oracle Products and Services VIRGINIA BEACH, Va., Feb. 6, 2012 /PRNewswire/ -- Mythics an elite Oracle Platinum value-added resale (VAR) product and training partner, an Oracle GSA Schedule holder GS-35-F-0153M and an award winning Oracle Platinum Specialized Consulting partner, today announced that it has been awarded a contract by the California Department of General Services (DGS) Procurement Division (PD) for Oracle software products and services.